Limiting Choices in a Combo Box

[dannyocean]

Hi All,

I am trying to limit the choices in a combo box based upon the answer in a previous field.

Ex. if [Product] = Medicare, then [market] choices are SA or CC or KC or IL.

TIA,

Danny

 

[AskMan]

You should have your records in a table.
Supposing you have a table myTABLE with the 2 fields [Products] and [Market].
You just have to :
- parameter your first combo like that
drpPRODUCT.Rowsource = "SELECT PRODUCT FROM myTABLE"

-and add this code into the drpMARKET_Click event
Private Sub drpMARKET_Click()
drpMARKET.Rowsource = "SELECT DISTINCT [MARKET] FROM myTABLE WHERE PRODUCT ='" & drpPRODUCT.value & "'"
End Sub [color]