Unable to save data modified in form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a relatively simple database with one main table, a couple of
supporting 'look up' tables and one form. the only mildly clever feature is a
field in the form that records when the record was last modified.

If i modify data in a form, Access gets stuck. I can't move on to the next
form or save the one i just changed. However the changes are actually
reflected in the main table.

If I don't modify data I can scroll freely through the forms.

any suggestions?
 
Graeme said:
I have a relatively simple database with one main table, a couple of
supporting 'look up' tables and one form. the only mildly clever
feature is a field in the form that records when the record was last
modified.

If i modify data in a form, Access gets stuck. I can't move on to the
next form or save the one i just changed. However the changes are
actually reflected in the main table.

If I don't modify data I can scroll freely through the forms.
Click to expand...

This is just a wild guess, but I wonder if you have your clever code in
the form's AfterUpdate event, and so you're dirtying the record
immediately after it was saved. That would get you stuck like that.
Code of that sort should go in the BeforeUpdate event, not AfterUpdate.
 
Back
Top