save current record in VBA code

  • Thread starter Thread starter emmy
  • Start date Start date
E

emmy

Hi there, I'd like to have a SAVE button on a bound form.
When the user clicks on the button, the current record
will be saved (if it's dirty), instead of having the user
move to another record using the record navigator.

Thanks a bunch!

Emmy
 
emmy said:
Hi there, I'd like to have a SAVE button on a bound form.
When the user clicks on the button, the current record
will be saved (if it's dirty), instead of having the user
move to another record using the record navigator.
Click to expand...

If you really need to do this, you can write

RunCommand acCmdSaveRecord

or

If Me.Dirty Then Me.Dirty = False
 
Back
Top