Parameter prompt

B

bbddvv

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!
 
V

Van T. Dinh

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