Using "All" In combo/List Boxes

  • Thread starter Thread starter Joe Gieder
  • Start date Start date
J

Joe Gieder

I saw an earlier post from someone trying to use "All" in
a combo/list box and tried to follow the same directions
by going
to "http://www.mvps.org/access/forms/frm0043.htm" and
following the directions there but it didn't work for me.
What I'm tring to do is have three combo boxes (Plant,
Title and Supervisor), by using the "Buyers Information"
table as the source pick any or "All" crietria from
within the combo/list box. I then went to my
query "Weekly Reports" and called the boxes on the form
there. The problem is I don't have a Union Query (or
don't know how to create one) so I get an error saying
the number of columns in the two selected tables or
queries don't match, I only have one table I'm using. Can
I use "All" as one of the criteria if I only have one
table? Do I need to creat a record with wild cards only
(*) to select? I tried the wild card and it didn't work.

Please help.
Thanks in advace for your help
Joe
 
You have to use the SQL view to creat a Union query. The basic syntax is

Select Field1, Field2
From YourTable
Union
Select Field1, Field2
From YourOtherTable
 
What I do is if the user wants to select all he leaves the
combo box blank. In my query for my criteria I use

like Forms![nameOfForm]![Amount] &"*"

Jim
 
Back
Top