Record Locking Problem on subform

[scottemotive]

Hi,

I have a form that is used for data entry

each user logs in, creates records and moves on to the next, (the record selectors at the bottom increment +1 each time and the ID (PK) increments to the next available number
which is fine, however

say a user enters 10 records it locks these 10 records in the table, which i think may be causeing locking problems and errors to show on use

Ill try to pinpoint what exactly my problem is but anyone got any ideas? im getting on_click errors intermittently (i have form -tblmain, sub form -tblsub)

thank you

 

[quest4]

I don't understand what you mean by:
a user enters 10 records it locks these 10 records in the table
You save then in a table or delete them from a table, but locking them? Are you maybe talking about the Record Locks in a form? hth.