Parameter query - select from list possible?

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.
 
D

Douglas J. Steele

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.
 
Top