Lookup Question

J

John Calder

Hi

I am a complete novice to Access and I use Win2K with Access 2K.

I have table that lists a series of codes, and a series of colors to match
each code.

In my form I have a combo box that lists the codes. I would like to have a
text box that looks at the entry in the combo box and then automatically
displays the corresponding color in it. Is this possible?

Any help is much appreciated

John
 
J

John Vinson

Hi

I am a complete novice to Access and I use Win2K with Access 2K.

I have table that lists a series of codes, and a series of colors to match
each code.

In my form I have a combo box that lists the codes. I would like to have a
text box that looks at the entry in the combo box and then automatically
displays the corresponding color in it. Is this possible?
Click to expand...

Do you need to see both the code and the color? i.e. are the codes
meaningful to the user? If not, just set the ColumnWidths property of
the combo box so that the code is of zero width (i.e. concealed from
view) and display the color.

If you do need to see both, put a textbox on the form and set its
Control Source to

=comboboxname.Column(n)

using the Name property of your combo box; (n) is the *zero based*
index of the field you want to display. So if the combo is based on a
query with the color in the second field use (1).

John W. Vinson[MVP]
 
Top