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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First Subform record gets modified when closing form 3
synchronized Combo Boxes in subforms 2
Combo box search from main form to subform 1
Subform dependent combo box 4
Subform fields auto-filled based on Main form combo box value 8
Combo Box results to Subform 1
Drop Down Combo Box Help? 1
requery a combobox in a continuious form subform 1

Back
Top