combo boxes

  • Thread starter Thread starter Lauren B.
  • Start date Start date
L

Lauren B.

How do I create combo boxes so that if one value is selected in the first
box, certain values appear in the second one. For example, my first box
will contain states. When a particular state is selected by the user, all
counties for that state will appear in the next combo box. This will occur
for all states.

Thank you for your help!

*Lauren
 
Lauren,
Assuming that your first combobox is called cboStates, then set the
rowsource for your county combobox to the following:

Select County
From Counties
Where State = Me.cboStates

Then, in the AfterUpdate event of cboStates put the following statement.

Me.cboCounties.Requery
 
Back
Top