This will take you to a new record, it doesn't insert a new record. A new record is inserted only once you have begun to enter information and it is updated to the table. Whatever you type into the text boxes is what will be stored.
The below code was created from the button wizard.
- Private Sub Command34_Click()
-
On Error GoTo Err_Command34_Click
-
DoCmd.GoToRecord , , acNewRec
-
Exit_Command34_Click:
-
Exit Sub
-
Err_Command34_Click:
-
MsgBox Err.Description
-
Resume Exit_Command34_Click
-
End Sub
I need to check for existing record before the record is inserted into the table, I am solved the problem with single quote check,
Thanks
Jambai