You can't go to the specified record

[Guest]

I've seen a tons of posts on this problem and none of the solutions have
helped.
Here's the deal,
Clicking the new record button on the navigation buttons bar works fine.
However, if i code a button to do DoCmd.GoToRecord,,acNewRecord i get the
error messge.
Furthermore, if i click debug on the rror, and then hit F5 to continue, it
goes to the new record anyways, so why does it give the bloody message in the
first place??
This is an extremely frustrating problem with access, and yes I am entering
all the required fields and I have allow additions to yes and i have the
recordset set to dynaset (inconsistent updates)

 

[Guest]

Solved my own issue:
For those of you who still have this problem, it could be that you are
trying to run two events simultaneously. In my case, I had code running for
the button's 'on click' event and it's 'on lost focus' event. Now that I have
removed the code from on lost focus everything is running peachy.

Andrew

 

[Mark via AccessMonster.com]

Do you get the error if you are at an existing record and then click your
button to go to the new record?

Chances are that you are already at a new record when your custom button is
trying to move there. The built-in "native" function of the navigation
buttons probably traps the error so it looks like the error isn't happening.