joys,

I assume that the second combo box is populated by a query which has a WHERE clause sensitive to the bound value of the first combo box.

If this is true, then select [Event Procedure] on the After Update event on the first combo box’s property sheet. Add a requery on the second combo box between the generated Sub…End Sub statements. It should look something like this:


Private Sub <first combo box name>_AfterUpdate()
....Me.<second combo box name>.Requery
End Sub


The Update event should fire when you change the value of the first combo box, repopulating the second combo box with the values dependent upon the new bound value of the first combo box.

__________________
Eudaimonia