You would need to use the change event of the first combo  box to set the
RowSource of the second combo box.

How you would do this depends on the way your data is organised and where it
is located.

You might need to use a filter on the data to select  the relevant data rows.