Error: You cannot go to specific record

[Jack]

Hi,
I am trying to add records in a form using standard code:

Private Sub Command29_Click()
On Error GoTo Err_Command29_Click


DoCmd.GoToRecord , , acNewRec


Exit_Command29_Click:
Exit Sub

Err_Command29_Click:
MsgBox Err.Description
Resume Exit_Command29_Click

End Sub


However, when I try to add record it gives the following error:
You can't go to specific record
This prevents me from getting the add button functional.
Any help is appreciated. Thanks

 

[molsonexpert]

Is "Allow Additions" in the forms property set to yes or no?

 

[Douglas J. Steele]

And if it's set to Yes, is the recordsource of the form updatable?

 

[Jack]

Yes,
Allow addition is set to yes.

Is "Allow Additions" in the forms property set to yes or no?

 

[Jack]

Actually, I was using a query related to single table for this job. Now
changing the recordsource to the table itself resolved the problem. Thanks