Drop down boxes before opening report?

[jimtimber]

Hi everyone,

I've made a query and designed a report for it. Simply it includes:

Area code, customer name, other customer details.


I want other people, when they click on the report to be given a drop down box which allows them to choose a specific area code before it generate the report. So, for example, they just want to look at Yorkshire region records, they choose Yorkshire from the drop down box and it'll generate the Yorkshire report. I've searched around but can't find what these are called.

Thanks,

Jamie

 

[pbaldy]

The drop down is called a combo box. You'd need to put one on a form to get one though. Then this would be one way to open the report:

http://www.baldyweb.com/wherecondition.htm

 

[jimtimber]

Thanks PBaldy, I'll have a go at making one this weekend and i'll ask any problems I have here. Thanks for the useful link too!
Jamie

 

[pbaldy]

Happy to help!