Prompt user to pick from list when running a report

[KLewisBPM]

When a user runs a report you can set the query to prompt a user for information i.e. insert the date.

Is it possible to set it so the user can pick from a list, for example if somebody wanted to view all the records associated with sales. Instead of typing in sales they were presented with a list. Like Sale,Personnel,Engineering etc.

Just a thought, but I would find this very useful when looking up information on a particular person, rather than writing their name in when prompted, I just pick it from a list.

Thanks

Kelley

 

[Stickarm]

You can create a form with a combobox or listbox that has the values for them to select from, then pass the value from that field into the query criteria.


Phil

 

[KLewisBPM]

I tried that I have a form with just the field as a combo box and the values are exactly what I want to see when I run the report. I have entered the form in the criteria of the field I want but not appearing when I run the report it still prompts me to enter information about that field.

 

[SgtJarrow]

The criteria should read something like

Forms![Name Of Form]![Name Of Combo Box]

And also the form must be open and you have to have picked one of the choices prior to running the query or report. There is no I in team.

Robert L. Johnson III, A+, Network+, MCP
robert.l.johnson.iii@citi.com