troubleshooting Question

Runtime Error 2001

Avatar of robinski
robinski asked on
Microsoft Access
7 Comments1 Solution306 ViewsLast Modified:

I have made some changes to a database that has been running for five years. It includes a combo box to find member's entries.

I have given myself the error message:

"" Runtime error 2001
   You cancelled the previous operation ""

I have not made changes to the combobox so I am perlexed as to where I should look for my error.

Code is below.



Private Sub MemberList_AfterUpdate()
    ' Find the record that matches the control.
    Dim rs As Object

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[Naim] = '" & Me![MemberList] & "'"

    'This next line is selected on error 2001

    Me.Bookmark = rs.Bookmark
    DoCmd.GoToControl "Surname"
End Sub

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 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 7 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