Select from List of Choices In Query

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

Guest

Can I create a query where it displays a list of choice for the user to
select. For example I have a query that ask the user to type in a departmen
name. Can they instead of typing in the name, can they select it from a list
that is displayed?

Thanks very much.
 
Ty said:
Can I create a query where it displays a list of choice for the user to
select. For example I have a query that ask the user to type in a departmen
name. Can they instead of typing in the name, can they select it from a list
that is displayed?
Click to expand...


It's time for you to abandon those quick and dirty parameter
prompt things. Instead, you can create a form with a combo
box for users to make their choice. Use a command button to
initiate the activitiy that is based on the query.

One way to filter the query is to replace the parameter
prompt with a parameter like Forms!theform.thecombobox

Better, if you are using the query as the record source for
a form and/or report, is to remove the criteria from the
query and use the OpenForm/OpenReport method's
WhereCondition argument instead.
 
I replaced the parameter in the query with the Forms!theform.thecombobox,
however, I did not see the options. The other method I did not understand how
to do?
 
The options are in the combo box on the form. You select
the option before running the query.
 
Back
Top