Runtime Error

[Thorny]

I am getting the following runtime error message when I try to use the following code:

Error message:
Method 'Item' of object 'Forms' failed

Offending line of code:
Forms!frm_main!txt_user = cbo_user_id

The Form "frm_main" is open and cbo_user_id contains a value as well.

This code runs fine on an Access 2002 but it falls over in Access 97.

Please help????

 

[adonet]

Try check data type.

 

[PHV]

And obviously the opened frm_main form contains a txt_user control and the BoundColumn property of cbo_user_id is the column number (starting at 0) of the desired value.
You may consider playing with cbo_user_id.Column(desiredColumnNumber)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244