I have a question about filtering on combo boxes. I was able to set up a form with 2 sub-forms, but it's more than what I need.
What I want it to do, is when the user makes the selection on the first combo box, I want it to filter on that selection and then drop that into the 2nd combo box. When the user makes the selection on teh 2nd combo box, then it should filter the results to a sub-form.
Any help? I have the relationships, and can get it to work when I have 1 form, and 2 sub-forms, but I really want just 1 form, with 1 subform.