On my customer list form, I have 2 list boxes 1 for customers, and 1 for job numbers.  The customer list filters the job numbers for the selected customer.  The job number list can be filtered 3 ways, All, Open, or Completed.  I have 3 subforms which get loaded into the subform control rather than using the tab control.  Is there a way to filter the loading subform to the job number selected on the main form rather than loading them all and the having to navigate the the selected job number.  I hope Ive explained this well enough.  If you need clearification please let me know.  Thank you in advance.