Populating Textbox based on dropdown menu

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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)
 
Back
Top