Parameter query - select from list possible?

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.

I don't think you can put a drop-down in a message box unless you actually use another small form.

I put the criteria combo box on the form I run the report from. If the combo is empty, the report returns all records. If a value has been selected, the report runs for that value only (you can either filter the report or run a second one pulling the selection as criteria).

Hope this helps!

Howard Brody



----- George Avery wrote: -----

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)


"George Avery" wrote in message
...
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.