I've been searching the internet and many other forums trying to figure this out but haven't gotten anywhere. The goal of my form is to have the user select options from a list box, then have the results displayed in a subform table. My form is set up like so:
1. Table with all data is called FY11 Budget Table, having many columns including Functional Category and Facility.
2. The first dropdown list for Functional Category is called Functional_Category_Pulldown
3. There is a second dropdown list for Facility which allows the user to select only facilities related to the selection from the functional category. 4. Once the selection in the facility box is made, the pertinent data is displayed in a subform.
The query for the Functional Category selection is (the <> is to exclude one value in the column):
SELECT [FY11 Budget Table].[Functional Category]
FROM [FY11 Budget Table]
WHERE ((([FY11 Budget Table]![Functional Category])<>"GSD FTE"))
GROUP BY [FY11 Budget Table].[Functional Category];
The query for the Facility selection, which is based off of the above choice, is:
SELECT [FY11 Budget Table].Facility
FROM [FY11 Budget Table]
WHERE ((([FY11 Budget Table].[Functional Category])=[Forms]![FY11 Budget Form]![Functional_Category_Pulldown]))
GROUP BY [FY11 Budget Table].Facility;
I really want the ability to select an 'All' option in both combo boxes so that the user has that capability.
Thank you for your time. As I am new to this forum, if you believe this posting is better served in a different area please let me know.