Hello,

I have a problem that started today when our Access system locked up. I have a query that has three tables that feeds an order entry form. When I go into the query to directly enter data into the query it will not let me enter in data. I go to one of my backups for the database and I can enter data into the query. If I copy the working query into my database the query stops working and I can not enter in data.

I can enter data directly into any of the three tables with no problem.

I would appreciate any help on this problem.

Double check and make sure no tables, fields have changed names.

If it's a query, you might want to check the RecordSet Type. Make sure it's
"Dynaset (Inconsistent Updates)"

Steven

I am a loud man with a very large hat. This means I am in charge