Parameter prompt

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

Guest

I have a report that prompts me for a value when opened. It the takes this
vlaue and returns the approptiate record. How do i make this prompt into
drop-down menu so i can select the parameter value from a list instead of
having to type it in?

Thanks!
 
Generally, you need to create a "Pre-Processor" Form with a ComboBox (where
the user can select a value) and a CommandButton to process the Report.

Use the full reference to the ComboBox as the Parameter in the Query being
used as the RecordSource for the Report.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Conditional Prompting for Parameter? 3
Query Parameter using multiple options 0
drop-down based on parameter query 4
MS Access 2003: Wild Cards Characters in Parameter Queries 3
The usual "Enter Parameter Value" prompt with combo boxes 4
Prompt in a Report 2
Parameter Query 2

Back
Top