Display alternate value in bound text box

J

JohnC

I need my form to display a value when a linked value is entered. I.e. if a
user enters there staff number I would like the text box bound to the combo
box to display to relevant name. For some reason I can't seem to get it to
work. Any thoughts?
 
J

Jason

Set the RowSource for the combo to a query that combines the staff number and
the name. Lets then say the combo boxes first column (actually numbered 0)
is the staff number and the second column (actual number 1) is name.
For the text box, set the control source to =MyCombo.Column(1)

Whenever you change the combo, the name will not be updated!!!
 
J

JohnC

Thankyou very much. Works perfectly!

Jason said:
Set the RowSource for the combo to a query that combines the staff number and
the name. Lets then say the combo boxes first column (actually numbered 0)
is the staff number and the second column (actual number 1) is name.
For the text box, set the control source to =MyCombo.Column(1)

Whenever you change the combo, the name will not be updated!!!
Click to expand...
 
J

JohnC

Don't suppose you know how to do the same thing on a report do you?!!! Sorry
to pester you!
 
Top