Combo Boxes?

A

Adam

I have a main form and a subform (1 to many). There is a combo box on my main
form that allows me to choose from a list of "campaign names." Based on the
name i choose on the one side a list of records are displayed on my subform
(the many side). THe subform also has a combo box and another subform on it.

I need my combo box in the subform to only show records based on what i
select in the main form. Currently it's showing all records.

Can anybody help??
 
O

Ofer

Make the rowsource of the combo in the sub form linked to the combo in the
main form

Select Field1, Field2 From TableName Where Field3 =
Forms![MainFormName]![ComboName]

On the after update event of the combo in the main form, run the code
Me.SubFormName.Form.ComboNameInSubForm.Requery

' To refresh the list after you change the campaign
 
Top