Forcing a Record to Save

[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.

 

[Allen Browne]

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.

 

[Josef]

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.

thx allen.