how do I force writing the data to a table?

[Morris]

I've got a form bound to query - an updatable one. Now when the user
clicks 'SAVE' I need to force saving the data to a table it's bound to
so that I can open a new recordset with updated values - before I
close the form.

Thanks,
Morris

 

[Allen Browne]

Take your pick:
Me.Dirty = False
RunCommand acCmdSaveRecord
Me.Refresh

Use error handling in case the record cannot be saved (e.g. required field
missing.)