Error msg when adding record from form

[njimack]

When trying to add a record from a form I'm designing, I get the following error message:

You can't go to the specified record.
You may be at the end of the recordset

I've searched Access help and the message board but can't figure out what this means or how to solve it.

 

[Norie]

How are you trying to add the record?

Does the form have a query/table as a record source?

Can you add records to that query/table in datasheet view?

 

[njimack]

I'm adding the record via a button I placed on the form using the wizard.

The form has a table as a record source

Yes, I can add records via datasheet view.

I've just realised that I have some fields which are required, which don't get populated by the form, which would obviously cause an error. Once I fix this, I'll report back if I still get the error.

 

[Norie]

Do you mean you are using code to add the record?

 

[njimack]

I added a button to the form, and then followed the wizard to enable the button to add the record. It has the following code:

Private Sub Button_Add_Record_Click()
On Error GoTo Err_Button_Add_Record_Click


    DoCmd.GoToRecord , , acNewRec

Exit_Button_Add_Record_Click:
    Exit Sub

Err_Button_Add_Record_Click:
    MsgBox Err.Description
    Resume Exit_Button_Add_Record_Click
    
End Sub

[/code]

 

[Norie]

That isn't really adding a new record, it's going to a blank record.

But obviously if you were entering a record and pressed the button the current record would be added.

If that current record was missing data for a field that is required I would think it would cause problems.

 

[njimack]

I've amended my form to include all the required fields but I still get the error message.

I don't understand what it means by "you may be at the end of a recordset".

Any ideas?