Report Criteria selection form

[marathonlady]

I have a report set up and on the criteria selection form the user can select the clients he wants the report run for, ie, Gas, Electric,
Other, etc, which are displayed via a combo box. In my query
I reference the form field in the criteria so the report will just get
the client asked for. How do I code the form so if they want a report on all clients?

Thanks in advance for any help.

 

[Full_Williams]

Not sure if this is the best way to do this, but it will probably work.

Add "All Clients" to your combo box. Create a new report w/o the criteria so it shows all clients.

When "All Clients" is selected have the new report run instead of the old.

Hope this helps,
Full Williams

 

[marathonlady]

To Full_Williams

Sounds good. I'll give it a try. Thanks!!