Using the unbound column of a combo box

  • Thread starter Thread starter Rob Brookbanks
  • Start date Start date
R

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
 
Is it possible to display the unbound value of a combo box in a different
text box and if so, how?
Click to expand...

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).
 
Back
Top