Using a list box inside a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have one field of data that I search by for all of my queries called
project. I have created a query called machine types that lists all of the
projects and I created a list box from the machine type query. I have
several queries that produce different subsets of the data. I want to use
this list box in my queries so the user can select the right "project" to
search by from the list box and then have the query run. I am an above
average access user but no programing knowledge. Thanks
 
Perhaps this sample database will be helpful. It shows how to use various
controls on a form as the filters for a query (the VBA programming builds a
WHERE string based on the data entered/selected in the controls), and then
passes that WHERE string to DoCmd.OpenReport action -- but can be modified
to use for showing a query's results directly.
http://www.accessmvp.com/KDSnell/SampleDBs.htm#FilterForm
 
Ken
Thanks for the info. I downloaded a couple of your samples last night.
Unfortunately I am not very fluent on what all the code means and how it
relates to what I need. Sorry. I guess I am looking for more guidance on
exactly what I need to do to use a list box along with my queries.
 
Back
Top