Combo Box Data

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

Guest

I would like a combo box to evaluate a selection and then retrieve data based
on that selection. For instance if I choose Model 1 then I want it to
retrieve the options for Model 1...Model 2 then the options for Model 2,
there may be several Options to evaluate. Thanks
 
I would like a combo box to evaluate a selection and then retrieve data based
on that selection. For instance if I choose Model 1 then I want it to
retrieve the options for Model 1...Model 2 then the options for Model 2,
there may be several Options to evaluate. Thanks
Click to expand...

Leave the combo box RowSource blank.
Assuming the name of the control that you are using to select the
Model number from is named [Selection], code that control's
AfterUpdate event something like this:

ComboName.RowSource = "Select TableName.* from TableName Where
TableName.ModelField = '" & Me![Selection] & "';"

Change the table and field names as needed.
 
Back
Top