“Add A New Record” function is not working (3 Viewers)

[access2010]

I would appreciate some help with the adding of new records to this form
@On Click = Event Procedure

= = =
Private Sub cmdAddNewRecord_Click()

On Error GoTo Err_cmdAddNewRecord_Click

' Save any current changes to the record

DoCmd.RunCommand acCmdSaveRecord

' Attempt to add a new record

DoCmd.GoToRecord , , acNewRec

Exit_cmdAddNewRecord_Click:

Exit Sub

Err_cmdAddNewRecord_Click:

MsgBox "Error " & Err.Number & ": " & Err.Description

Resume Exit_cmdAddNewRecord_Click

End Sub

= = =
Error Message
Stock Name and Stock Symbol already exists on the investments01_Tbl => OK

= = =
You can’t go to the specified record

Thank you Barbara

 

[DHookom]

I suggest you review this thread about saving records in a bound form.

 

[access2010]

Thank you DHookom, for your suggestion.

We have been using the code in this database since 2010 without any issue until now, specifically, “ONLY in THIS FORM”.

We have tried many other codes without success and would appreciate your assistance with this problem.

 

[LarryE]

I would appreciate some help with the adding of new records to this form
@On Click = Event Procedure

= = =
Private Sub cmdAddNewRecord_Click()

On Error GoTo Err_cmdAddNewRecord_Click

' Save any current changes to the record

DoCmd.RunCommand acCmdSaveRecord

' Attempt to add a new record

DoCmd.GoToRecord , , acNewRec

Exit_cmdAddNewRecord_Click:

Exit Sub

Err_cmdAddNewRecord_Click:

MsgBox "Error " & Err.Number & ": " & Err.Description

Resume Exit_cmdAddNewRecord_Click

End Sub

= = =
Error Message
Stock Name and Stock Symbol already exists on the investments01_Tbl => OK

= = =
You can’t go to the specified record

Thank you Barbara

 

[LarryE]

You don't need the save record command at all. ACCESS saves records automatically. If you can't add records, then check the record source and make sure it allows new records to be added. If you still can't add records then check the form properties. Someone changed something.

 

[GaP42]

see also this thread for same issue, from same OP https://www.access-programmers.co.u...-record-button-events-are-not-working.334486/