Combo Boxes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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