To do the multi-combo box
each combo box has a query for its recordsource.
Here the user picks a state, then in the next combo picks a City (in that state)
The 1st combo,(say cboStates)... User picks a state, then picks a company from the cboCity box.
The cboStates AfterUpdate event will trigger when the user picks it, and this will update the next combo.
Code:
sub cboStates_AfterEvent()
cboCo.requery
end sub
The cboCity query (say qsCityViaState) will reference the cboStates in the query sql
Select [city] from tZipCodes where [ST] ='" & forms!frmMain!cboStates & "'"
The City combo must be refreshed (cboCity.requery action) after user picks the state so it can deliver the resulting dataset.
If there is another combo after this say cboEmps to pick employees, then the cboEmp must be refreshed after user picks cboCity.
Code:
sub cboCity_AfterEvent()
cboEmps.requery
end sub