how do I force writing the data to a table?

  • Thread starter Thread starter Morris
  • Start date Start date
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
 
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.)
 
Back
Top