Access 2007 runtime error 2142
Posted on 2011-10-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:
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.