Parameter query - select from list possible?

  • Thread starter Thread starter George Avery
  • Start date Start date
G

George Avery

Is it possible to have the dialogue box that pops up to
get a parameter, formatted as a combo box that users can
select a value from.

I have a button on a form which opens a preview of a
report based on a query where the parameter is [What
Category?]. The field [Category] is populated during data
entry from a pick list and I'd like to provide the same
choice for users when viewing the report.
 
There's no way to control the dialogue box that appears. However, you can
open your own form that has a combo box on it, and have the query look for
that combo box, rather than your generic parameter.

Instead of [What Category?], put Forms![MyPromptForm]![MyComboBox]. The
query won't work, though, unless the form is open.
 
Back
Top