Ok,
If I load the form [frmMember] in 'Add mode', fill it out, click my save button (performs DoCmd.RunCommand acCmdSaveRecord) the cmdAddANewMember button on frmMember works correctly and re-loads frmMember in 'Add Mode', but...
If I load the form [frmMember] in 'Edit mode', whether I make some Edits or not, and/or click the Save button or not, the same cmdAddANewMember button says
"You can't go to the specified record."
How can I correct this to work in both 'Add Mode' and 'Edit Mode' conditions?
or better yet, how can I make the cmdAddANewMember button disapear in the edit mode???
This is the Code I am using at this time:
Private Sub cdmAddANewMember_Click()
On Error GoTo Err_cdmAddANewMember_Click
DoCmd.GoToRecord , , acNewRec
Exit_cdmAddANewMember_Click:
Exit Sub
Err_cdmAddANewMember_Click:
MsgBox Err.Description
Resume Exit_cdmAddANewMember_Click
End Sub