Using two combo boxes, need a select "all" option, so that filter turns off
for that combo box and records matching all the criteria in the first box
and
only the criteria selected in the second box are retrieved.
I have this in my rowsource: SELECT DISTINCT [SNM Data].[SNM Type] FROM
[SNM
Data] UNION Select "(All)" as Bogus From [SNM Data]
ORDER BY [SNM Data].[SNM Type];
and in my criteria for the query I have this
Forms!NameOfForm!NameOfCombo Or (Forms!NameOfForm!NameOfCombo Is Null)
an "all" shows up in my combo box, but when I use it as a selection, no
records come up. I want it so that ALL the records come up. Any help
would
be much appreciated.
