combo box question

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

Lauren B

How can I set up two combo boxes so that when a state abbreviation is
selected in the first one (pulling from the field STATE), the counties for
that particular state appear in the second combo box. I have a table that
contains a list of all counties (field = COUNTY) by state abbreviation
(field= STATE)

Thank you for any assistance.

LB
 
In the query behind your second combo box, include the State field, and
as a criteria for that field...
(use your own names)
= cboState
After updating cboState, requery cboCounty.
It should now only display counties associated with the state selected in
cboState.
Your using cboState value to filter the results returned by cboCounty...
hth
Al Camp
 
Back
Top