Error: You cannot go to specific record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Is "Allow Additions" in the forms property set to yes or no?
 
And if it's set to Yes, is the recordsource of the form updatable?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Debugger runs but unwanted 8
Write report to file code 6
Duplicate record question again with code? 3
Form not opening correctly 2
Combo Box with a event procedure 1
Insert Into SQL string from form 1
Add Record command button error message 2
Add new record command button not working in tabbed form 1

Back
Top