form freezes after data entry

H

hbear

I have a form that is freezing after each new record is entered. It will not
advance to a new record from the last field or from my save button. I get
the error message: "You cannot go to the specified record, you may be at the
end of a recordset". The macro attached to the save button is simply a
goto.NewRecord.
Also, all the menu buttons appear to freeze. The only way out of the form is
to close out. I then receive a message telling me the record cannot be
saved, although it has inevitably saved when I reopen the form.
What am I doing wrong?
 
A

Arvin Meyer [MVP]

Try using code in the button:

Sub cmdSave_Click()
DoCmd.RunCommand acCmdSaveRecord
DoCmd GoToRecord acNewRecord
End Sub
 
H

hbear

Thank you for your help. It seems simple enough. I cut and pasted, but the
code is generating "Run-time error number 2493: This action requires an
Object Name argument." Interestingly enough, the original error message I
got was: "You are trying to access property |." That seems to have been
banished in favor of the first, for now, though.
 
H

hbear

Sorry for failing to acknowledge your response. Time got away from me. I
did rebuild, however, and haven't had a recurrence. Thanks for your help.

bear
 
Top