Using the unbound column of a combo box

[Rob Brookbanks]

Is it possible to display the unbound value of a combo box in a different
text box and if so, how?

For example, I choose a customer from a dropdown box which selects
Accout_Ref and CustomerName from a table. The combo is bound to Account_Ref,
whose width is 0 and the second column displays CustomerName. I want to
choose the customer from the dropdown box, then after update, lock it, hide
it and display CustomerName in a seperate tetxbox that has become visible on
the after update of the combo box while I do some other processing on the
form.

TIA,

Rob

 

[John Vinson]

Is it possible to display the unbound value of a combo box in a different
text box and if so, how?

Yes: set the Control Source of the textbox to

=comboboxname.Column(n)

where (n) is the *zero based* subscript of the field you want to see
(e.g. Column(2) is the third column in the combo's rowsource query).

 

[Rob Brookbanks]

That makes absolute sense and sounds perfect, thanks very much