D
DavidW
I have three comboboxes on a form - Fabric, Degree, Color.
The row source type for each is Table/Query. The row source is a Select
Distinct query. I'm using a query so the list will populate itself.
The choices the user makes in the comboboxes are used to filter called
forms.
Would there be a way to include the word "ALL" in a drop down list
in addition to the data generated by my query. If the user chooses
"ALL", the called page will not be filtered on that particular
choice. I just created a record with "ALL" in those particular
fields. That seems to work, but I think there might be a better way.
Thanks
The row source type for each is Table/Query. The row source is a Select
Distinct query. I'm using a query so the list will populate itself.
The choices the user makes in the comboboxes are used to filter called
forms.
Would there be a way to include the word "ALL" in a drop down list
in addition to the data generated by my query. If the user chooses
"ALL", the called page will not be filtered on that particular
choice. I just created a record with "ALL" in those particular
fields. That seems to work, but I think there might be a better way.
Thanks