how do I force writing the data to a table?

M

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
 
A

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.)
 
Top