making fields in a form dependant on each other

[Guest]

How can I use the selection in one fiels combo box to determine the content
of another fields combo box in my form?

 

[Guest]

With a filter that refer to the value in the first combo.
In the RowSource of combo2 add a filter to combo1

Select FieldName From TableName Where FieldName = Forms![Formname]![ComboName]
=========================================
On the after update event of combo1 run the code
Me.Combo2Name.Requery

To refresh the List of combo 2

 

[Van T. Dinh]

I think you meant a set of cacaded ComboBoxes.

See The Access Web article:

http://www.mvps.org/access/forms/frm0028.htm

 

[el bebe]

I've seen that article and I can't understand it. I copied and pasted the
text there and the result is not what we're looking for.

Can someone explain the code in that page?