Save and New

  • Thread starter Thread starter allen davidson
  • Start date Start date
A

allen davidson

Hi, I'm trying to have a button on a form that saves the current record then
clears the form ready for another record to be entered.

The form is opened from another form like this

DoCmd.OpenForm "frmOrganisation", acNormal, , , acFormAdd, acDialog

The code for the button click is

If Me.Dirty them
Me.Dirty = False
Enf if

I'm using Access 2003. I think I need to use AddNew but not sure how to go
about it.

Regards
Allen
 
This seems to work OK (simpler than I was trying)

If Me.Dirty Then
Me.Dirty = False
End If

DoCmd.RunCommand (acCmdRecordsGoToNew)

Any downside of doing it this way?
Thanks
Allen
 
Back
Top