Add Record Control

[mkelly]

I have a form that used to work.

You fill in all the data and hit the "ADD RECORD" button.
before it would change to a new screen to add another record.

Now when I click the button I get an error message:
"You can't go to the specified record"

Any advice? Help?
Much appriciated.

 

[Rob.Mills]

Has the form's Allow Additions been changed to no?

 

[mkelly]

additions

no it is still set to "yes"

 

[Rob.Mills]

What about your recordsource? It sounds like this is now not an updateable recordsource.

Are you able to edit existing records?

 

[mkelly]

edits

Yes I am still allowed to edit the existing data

 

[Rob.Mills]

What's the code behind your button?

 

[mkelly]

code

Private Sub add_record_Click()
On Error GoTo Err_add_record_Click


DoCmd.GoToRecord , , acNewRec

Exit_add_record_Click:
Exit Sub

Err_add_record_Click:
MsgBox Err.Description
Resume Exit_add_record_Click

End Sub

 

[Rob.Mills]

I'm afraid I'm not sure where to go from here. Everything looks good from this end.

If you want you can send me the db. You'll have to send it uncompressed. My email is robert.mills@zcsterling.com