Save Record

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I need to have the form save the current record after one
of the controls looses focus. I'm new to coding and have
come up with the below code. When the control looses
focus no error messages appear but the record isn't
saved.
Thanks,
Rob


Private Sub DDPosition_LostFocus()
On Error GoTo Err_DDPosition_LostFocus

DoCmd.RunCommand acCmdSaveRecord

Exit_DDPosition_LostFocus:
Exit Sub

Err_DDPosition_LostFocus:
MsgBox Err.Description
Resume Exit_DDPosition_LostFocus
End Sub
 
Hi Rob, I can't see a problem with the syntax you've used. I have no
problems with

Me.Dirty = False

Cheers, Graeme.
 
Back
Top