That's not the code I suggested.
The Add button uses the Me.Dirty code. The Delete button uses the Me.NewRecord test.
That's not the code I suggested.
The Add button uses the Me.Dirty code. The Delete button uses the Me.NewRecord test.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
It works!
I simply put
behind cmdAddRec and it now allows me to advance to a new record and ad data.Code:Me.Requery DoCmd.GoToRecord , , acNewRec
Thank you for the help!