My Member Form locks when entering new members.

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

I've inherited an Access 97 database. A new problem has
cropped up. When entering new members, 1, 2, or more
records may be entered fine. Then, for no apparent reason,
the form locks when trying to enter another new record.
Sometimes, but not always, the previous record is locked
in the form also. Existing records are still editable
and ALL database records can be updated in the table
view including the new record. The only way I have been
able to unlock the form is to import the form from a
backup?

What is going on? How can I prevent this from happening?

Thanks,
Terry
 
What do you mean, the record or form is "locked"?

Does the problem persist if you close & then re-open the database?

TC
 
The form does not allow me to enter or change data in any
of the fields.

And yes, the problem persists until I either replace the
form or delete the database and restore it from a backup.

Terry
 
On one hand, it sounds like a programming issue within the form. On the
other hand, this seems unlikely, because a form can not store information
permanently, within itself. You say that replacing the form (not the whole
database) is enough to fix the problem. This suggests that whatever is
changing, is changing, permanently, within the form itself.

Can't see much to suggest, without seeing the code behind the form. Maybe
see if the code changes the AllowEdits property of the form.

HTH,
TC
 
Back
Top