I can't edit a form until I move to the next record, very odd!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

efandango - 17 Nov 2007 10:47 GMT

I have a Master form with a master record, when I open the form, i am unable
to edit the data on that form until i move to the next record. I also have
lots of other forms on other tabs, some linked, some unlinked to the master
form, I have the same problem with all these other forms too; I can't edit
them until i move to the next record, then I am able to edit any record (or
subform) on the master form. Does anyone know why this oddity is happening?

Reply to this Message

Rick Brandt - 17 Nov 2007 13:50 GMT

> I have a Master form with a master record, when I open the form, i am
> unable to edit the data on that form until i move to the next record.
[quoted text clipped - 3 lines]
> then I am able to edit any record (or subform) on the master form.
> Does anyone know why this oddity is happening?

Did you create these forms?

There could be code in the Open or Load event that locks the record and code in
the Current event that unlocks them, but you would have had to put that code
there if these are forms that you built. Otherwise nothing immediately comes to
mind as to what would cause this.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message