troubleshooting Question

runtime error 2105

Avatar of suddzy1981
suddzy1981 asked on
Microsoft Access
2 Comments1 Solution618 ViewsLast Modified:
getting error message run-time error 2105   cannot go to specified record

here is the code for the form that I have....its at the bottom on the Private Sub submit_Click()

Private Sub Form_BeforeInsert(Cancel As Integer)
Call UsersName
Me.INSERT_USER = Username
End Sub


Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub

Private Sub cmd_Clear_Click()
On Error GoTo Err_cmd_Clear_Click


    DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70

Exit_cmd_Clear_Click:
    Exit Sub

Err_cmd_Clear_Click:
    MsgBox Err.DESCRIPTION
    Resume Exit_cmd_Clear_Click
   
End Sub
Private Sub cmd_Close_Click()
On Error GoTo Err_cmd_Close_Click


    DoCmd.Close

Exit_cmd_Close_Click:
    Exit Sub

Err_cmd_Close_Click:
    MsgBox Err.DESCRIPTION
    Resume Exit_cmd_Close_Click
   
End Sub

Private Sub submit_Click()
DoCmd.GoToRecord , , acNewRec
Exit Sub
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros