Textbox must lookup value in combo box and display on form

E

Esrei

Hi
Very new to access but getting there
On a combo box on a form it is linked to a tabel with 4 columns. the first
colum the ID is placed in another field correctly, but only the value in the
2nd column is displayed, I want the 2nd, 3rd and 4th to be displayed on the
form this data is not sored in the tables it is just for display purpose when
the tables are updated with the form.
Thanks
 
D

Dennis

Set the control source property for each of your text boxes to
=YourComboBoxName.Column(1)
=YourComboBoxName.Column(2)
etc.
 
Top