"MS Access 2010 ErrorCode 2046 Command GoToRecord is currently not available" error

[accessmatt]

Hello,

I just started getting this weird error message. when I open Access. MS Access 2010 ErrorCode 2046 Command GoToRecord is currently not available

I should mention that Access defaults to a form on open and I'm using this VBA to default to a new record in the form.

Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub

Any ideas?

[Thompyt]

Are you already at the new record.

[Missinglinq]

What, exactly, does "...I just started getting..." mean? Did the Form work as you wanted it to, before, going to a New Record on opening?

Does it go to a New Record if you open the Form by clicking on it in the Object Pane?

The most common reason for popping this error is that the Form is Read-Only. What is the Form based on...a Table? A Query? If a Query, does it include multiple Tables?

If opened independently, can you add a New Record?

Linq ;0)>

[accessmatt]

Hi,

Still encountering this issue. Linq, it seems to be a sporadic occurrence. Sometimes I get the error and sometimes not. Once I press end than it opens my form but with the last record populated in the form fields. I press enter and it goes away. Nothing is read only. Does that help?

[Missinglinq]

...it seems to be a sporadic occurrence...

This bit, given your scenario, pretty much points towards corruption of the Form. The first approach, when corruption like this is suspected, is usually to create a new file and Import everything into it. It only takes a couple of minutes, frequently works ans causes no problems if it fails.

Linq ;0)>