Your 2nd query is a parameter query that gets its data based on whatever
is selected in the 1st combobox. In order for the 2nd Combobox to
repopulate with the correct data after a selection is made from the 1st
combobox, You need to requery the form. You can do this in the Click
event of the 1st combobox
Private Sub 1stCombo_Click()
Me.Requery
End Sub
Additionally, for data entry purposes, you may have better results with
a single form rather than a continuous form (go to form Design view -
select the form property sheet and select Single Form in the Default
View property).
Rich
*** Sent via Developersdex
http://www.developersdex.com ***