If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Parameter query - select from list possible?
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. |
#3
|
|||
|
|||
Parameter query - select from list possible?
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. |
Thread Tools | |
Display Modes | |
|
|