List Box within a query

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

Guest

In a query if you want a user to enter data I have always used the [Enter
blah blah] in the design of the query so the user will be propmted to enter a
date, name etc. When the enter parameter box comes up is there a way to link
that to a list box made up from a different table. What I would like to do is
prompt the userto eneter a Project Manager but also show them a list they can
choose from.
 
The query parameter dialog cannot use a list box.

However, you can create an unbound of your own, open it and select the
value, and then have the query read the value from your form.

The criteria in your query would refer to the list box like this:
[Forms].[Form1].[List0]
 
Back
Top