M
Milan
No VB required,
Put the first value in a combo-box that has two columns:
the value and the description. Then have a second control -
a text box whose control source is bound to the second
column of the combo-box.
For example the first value is called Code and the second
is called Desc. Have a combo-box called Code bound to the
field Code. The text box control source is in this case:
=Code.Column(1).
You don't need to requery anything, whenever you select
another value in the combobox, your text box will
automatically show to the new value.
P.S. You can leave both columns in the combo-box visible
or hide the second value (Desc) by setting width to 0;1
for example.
Milan
Put the first value in a combo-box that has two columns:
the value and the description. Then have a second control -
a text box whose control source is bound to the second
column of the combo-box.
For example the first value is called Code and the second
is called Desc. Have a combo-box called Code bound to the
field Code. The text box control source is in this case:
=Code.Column(1).
You don't need to requery anything, whenever you select
another value in the combobox, your text box will
automatically show to the new value.
P.S. You can leave both columns in the combo-box visible
or hide the second value (Desc) by setting width to 0;1
for example.
Milan