<div>
I'll check first thing tomorrow morning. Thanks for the tip
</div>


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

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


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

<div>
<div class="content wysiwyg-content">
I have an app with a list box lst_ProjNames. On AfterUpdate of the list box I set focus to another control:<br />
<br />
<b>Combo0.SetFocus</b><br />
<br />
and search for a record:<br />
<br />
<b>DoCmd.FindRecord Me.lst_ProjNames.Column(0)<wbr /></b><br />
<br />
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...). &nbsp;I have verified that the value returned by <b>Me.lst_ProjNames.Column(0)<wbr /></b> is correct and valid, and identical to the value returned in my copy of the app on my workstation.<br />
<br />
I'm stumped - why the error on the user's workstation?? Any suggestions would be appreciated.<br />
<br />

</div>
</div>


I have an app with a list box lst_ProjNames. On AfterUpdate of the list box I set focus to another control:

Combo0.SetFocus

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.



Access 2007 runtime error 2142

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.

Web Development

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.