How to Go About Reports/Queries from MULTIPLE Listboxes

I am trying to design a database storing records for a mapping company. I
have a form with 3 listboxes: one for company (client), one for project, and
one for site. Each of these listboxes has a separate command button that
runs a query returning results for those individual listboxes. However, I am
trying to set up a separate button that runs a query returning results for
any/all selections from ALL 3 listboxes. I don't know enough VBA code to
figure it out on my own, but I can't find another non-VBA method.
Also, each listbox has a 2nd button for generating a report based on the
selection. Is this possible? And like with the queries, I need a button
capable of generating a report based on any/all selections from all 3
listboxes.
I have been working on this for days and am getting nowhere. Any help would
be appreciated.

I assume each of your list boxes is multi-select. There is a generic function
for this with sample usage at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane.
--
Duane Hookom
Microsoft Access MVP


"Zachary" wrote:

I am trying to design a database storing records for a mapping company. I
have a form with 3 listboxes: one for company (client), one for project, and
one for site. Each of these listboxes has a separate command button that
runs a query returning results for those individual listboxes. However, I am
trying to set up a separate button that runs a query returning results for
any/all selections from ALL 3 listboxes. I don't know enough VBA code to
figure it out on my own, but I can't find another non-VBA method.
Also, each listbox has a 2nd button for generating a report based on the
selection. Is this possible? And like with the queries, I need a button
capable of generating a report based on any/all selections from all 3
listboxes.
I have been working on this for days and am getting nowhere. Any help would
be appreciated.