combo boxes

[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

 

[Lynn Trapp]

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