Access 2007 runtime error 2142

Posted on 2011-10-12
Last Modified: 2012-05-12
I have an app with a list box lst_ProjNames. On AfterUpdate of the list box I set focus to another control:


and search for a record:

DoCmd.FindRecord Me.lst_ProjNames.Column(0)

This works as expected on my development workstation. However, when a user tries to perform a lookup - using identical data on a network share and an identical copy of the app on his workstation - on AfterUpdate of lst_ProjNames he gets Runtime Error 2141 (The FindRecord action requires a Find What argument...).  I have verified that the value returned by Me.lst_ProjNames.Column(0) is correct and valid, and identical to the value returned in my copy of the app on my workstation.

I'm stumped - why the error on the user's workstation?? Any suggestions would be appreciated.

Question by:dgmoore1
    LVL 119

    Accepted Solution

    check the copy of the app on the user workstation.
    make sure that there is no "MISSING" references.

    Author Comment

    I'll check first thing tomorrow morning. Thanks for the tip

    Author Closing Comment

    This was the issue - I have Office 14 and my users have Office 12. Changing the reference fixes the problem.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now