Cascading Comboboxes 1

[TeriCoombes]

Is it possible in ADP to have a combobox in a form that filters a second combobox in the subform? I am developing a purchase order database where an employee would select the company and then the subform combobox would list only those items sold by that company.

 

[danvlas]

In the AfterUpdate event of the combo on main form:

Me("SubFormName").Form("SubformComboName").RowSource = "Select * From ViewName Where ComboField = " & Me("MainFormComboName")

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[TeriCoombes]

You are so awesome! It worked. Thank you.