Textbox must lookup value in combo box and display on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Set the control source property for each of your text boxes to
=YourComboBoxName.Column(1)
=YourComboBoxName.Column(2)
etc.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box on Main Form and limits Combo Box selection on the Subfo 1
Combo Box QUESTION 5
Access Combo Box display 1
Combo Box in Continuous Form 1
return value based on combo box selection 3
combo box data type 1
combo box 1
Blank combo or list box 1

Back
Top