Creating Drop Down Menus in a query

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

Guest

I'm trying to create a query that would allow people to choose from all of
the options in a certain field. i.e. when the query is executed the person
will be prompted to choose from a drop down list to open up the query. But,
I want the query to choose from the field in the table so that I don't have
to continually update my query with any additions. Hope this makes sense.
Thanks in advance.
 
You can create a form, and place the combo box on it. Add a button to
perform the action needed.

If you want the combobox to display field names from a table, set the
rowsource type to 'Field List'.
 
Back
Top