I
Italian Pete
I have a combo box populated by a query that returns two fields, a UserName
field and a User_id field. The combo displays just the UserName (the User_id
column width is set to Zero) whereas the Bound property of the combo box is
set to 2 (which corresponds to the User_id).
On opening this form from a data input form, I want the Default Value of the
combo box to be equal to the UserName in a text box in the input form.
However, the Default Value seems to need to be a number (I imagine from the
fact that the bound property is set to 2).
How can I get round this problem?
Many thanks, Pete
field and a User_id field. The combo displays just the UserName (the User_id
column width is set to Zero) whereas the Bound property of the combo box is
set to 2 (which corresponds to the User_id).
On opening this form from a data input form, I want the Default Value of the
combo box to be equal to the UserName in a text box in the input form.
However, the Default Value seems to need to be a number (I imagine from the
fact that the bound property is set to 2).
How can I get round this problem?
Many thanks, Pete