Forcing a Record to Save

  • Thread starter Thread starter Josef
  • Start date Start date
J

Josef

hi,

i have a problem that when i move between forms i get a dialog appearing
that stated that data has been changed, and to either save/copy to
clipboard, or drop changes.

on one form i reference one table, but in another i reference 2 tables.

is there any way to save the current record before moving to the next
form and stop the dialog from returning ?

thanks.
 
To save the current record, set its Dirty property to No:
If Me.Dirty Then
Me.Dirty = False
End If

That approach works even if the form does not have focus, and generates a
trappable error message if the save fails for any reason.
 
To save the current record, set its Dirty property to No:
If Me.Dirty Then
Me.Dirty = False
End If

That approach works even if the form does not have focus, and generates a
trappable error message if the save fails for any reason.
Click to expand...

thx allen.
 
Back
Top