Populating Textbox based on dropdown menu

G

Guest

I have a simple table.

3 Rows. Printer Name , Location , Model

Based on the dropdown list that will contain the printer names I want to
populate it's location and model in the 2 text boxes supplied.
 
G

Guest

Make sure that the combo row source include all three fields
Select [Printer Name] , Location , Model From TableName

On the after update event of the combo, you can write
Me.[Location Field Name In the form] = Me.ComboName.Column(1)
Me.[Model Field Name In the form] = Me.ComboName.Column(2)
===========================================
Or, in the control source of each of the fields you can write
In the location
=[ComboName].column(1)
In the Model
=[ComboName].Column(2)
 

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

Top