making fields in a form dependant on each other

W

Waynef

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

Ofer

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
 
E

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?
 
Top