Filter subform Combobox from Main Form Text Box

[Kelsey]

Hello all,
I know how to filter 2 combo boxes in a subform, but can't figure out how I would filter a combo box in a subfrom from a text box in main form. I have a main form "frmIssue" with a "JobID" text box. My subform is called "frmIssueSub" and has combo "OperationNumberID" and "JobID". I need to be able to only show Operation Numbers from the set JobID in my main form.
Thank You
Kelsey

 

[Adam Caramon]

If I understand what you're saying, you could base the combobox in the subform on a query that has its criteria connected to the main form's textbox. Then, when you change something in the main form text box, add in code that requerys the subform.

That would be my best guess.