List box for a query

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

Guest

What I wanted to know if there is a way with VBA that a query field could
call up a module that would display a pop box for the user to select from a
list of values for the query to run against.

I already know you can do this through use of a form as the front end and
then passing the values around but the way some of it was set up was a user
sets the values on a form and hits a command button programmed to run another
form that utilizes the values from the first form to display the results.
The users are using a lot of different front end forms for a lot of the same
value.

I'd just like the idea a little better of calling a module in the queries
for the values the user has to enter and instead of a form, it's just a
listbox that is displayed and selected out of.

Didn't know if it was possible and so far I can't find that it is. Just
thought I'd ask some experts.
 
A form is the way to do this. Queries don't have the ability to "pop up"
complex objects such as a listbox.
 
Back
Top