• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 570
  • Last Modified:

Access 2007 runtime error 2142

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.

  • 2
1 Solution
Rey Obrero (Capricorn1)Commented:
check the copy of the app on the user workstation.
make sure that there is no "MISSING" references.
dgmoore1Author Commented:
I'll check first thing tomorrow morning. Thanks for the tip
dgmoore1Author Commented:
This was the issue - I have Office 14 and my users have Office 12. Changing the reference fixes the problem.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now