select all

Tech-Archive recommends: Fix windows errors by optimizing your registry

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.


.

Relevant Pages

  • RE: Filtering a subform using many combo boxes
    ... I followed you instructions to the letter and every one of the criteria ... I described the typical properties of all my combo boxes in my original ... open the query "qryProjects" in design view. ... I have a main table named tblProjectData that contains all the data for each ...
    (microsoft.public.access.forms)
  • Re: Date programming question.
    ... If you remove the Criteria, ... Allen Browne - Microsoft MVP. ... In the Detail section of the form are 3 more boxes. ... Since the form is in Tabular format it will list all ...
    (microsoft.public.access.modulesdaovba)
  • RE: Graph wont show
    ... It looks like you have two combo boxes on the form. ... I modified my query and it still won't take any null value from the criteria ... I still can't figure out why no selection of criteria results in graph not ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
  • Re: I know this quesion has been asked a million times but.....
    ... I have 4 boxes. ... dodaac, ... If I enter the criteria for the dodaac and the profit center I can search by ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.forms)
  • Re: BuildCriteria Results --- To Marshall Barton or ?
    ... When you're using BuildCriteria, ... two text boxes for start and end dates. ... >beginning date in one ctl and an ending date on another ctl, ... >>>> nothing to do with the kind of criteria (although your idea ...
    (microsoft.public.access.formscoding)