Looking for a way to add 4 combo boxes to a user form that select based on
the results of the previous combo box. Help ??
Please answer here in the NG.

This is the very basic answer.
Assume you have 2 boxes Combo0 and Combo2.
assume Combo2 is based on a query named "emp".
Use the onchange event of Combo0.

Private Sub Combo0_Change()
If Me.Combo0 = "C01" Then
Me.Combo2.RowSource = "admin"
End If
Me.Refresh
End Sub

If "C01" is picked in Combo0, Combo2 will now be based on the query
"admin"


For four of them and for multiple values you have a lot of grunt work
to do but this is the general idea.

Good luck

Ira Solomon


On Thu, 11 Nov 2004 09:01:10 -0500, "me" <noway (AT) cox (DOT) net> wrote: