in forms i want to make one combo box dependint on another

[Guest_imported]

i know how to creat a combo box that contains the information i want but i cant make it dependent on the perciding one,

ex: if in the first box i pick boy, i want the choices in the second to be jack, jim, etc, but if i put girl in the first i want the choices in the second box to be jill, brenda, etc.

can any one help me with this prolbem

thx

 

[jfischer]

In the AfterUpdate event for the first combo box, do a Requery action on the second combo box. For example:

Private Sub Combo1_AfterUpdate()
  'Modify the RowSource of Combo2 here (if needed), then
  Me!Combo2.Requery
End Sub

 

[kcsteve]

jfischer or shaman...

any ideas on how to take this another step?

e.g. how to make a third combo dependent on the selection in the second combo (which was filtered based upon the selection in the first combo)?

 

[krnsmartazz]

me.requery = null