|
Subject:
|
Filtering Combo Boxes
|
|
Posted By:
|
sburgess
|
Post Date:
|
8/28/2006 9:08:46 AM
|
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.
|
|
Reply By:
|
SerranoG
|
Reply Date:
|
8/28/2006 10:01:36 AM
|
Search the archives here for the phrase cascading comboboxes. It's just a matter of changing the rowsource of the second combobox with an After Update event from the first one.
Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
|
|
Reply By:
|
sburgess
|
Reply Date:
|
8/28/2006 10:40:23 AM
|
I did a search in the archives for "cascading comboboxes" and there were no actual matches, just a bunch of links that might have something relating to it.
|
