SETTING CRITERA FOR A REPORT 1

[spence27]

HI

I was wondering if someone can help point me in the right direction.

I am building a few reports in access(2000) and the querys they are based on need a parameter to be passed. I can do this manualy but he idea is to have these reports run in batches. So i need a way to pass the parameter(s) over to the report either from a macro or preferably VBA.

P.s. Can you make it as idiot proff as possible

Thank Spence

 

[nberryman]

In brief

Create a blank form and add a combo box and name the combo box.

Leave the form open edit your query and in the criteria field delete the parameter and click the build button and run the Expression Builder.

Double click Forms, Open forms and select the Combo bx created earlier. The content of this now become your criteria so evertime you run the report it will look at the form.

Create a macro to open, print and close each report and run it from a command button.

That should do it



Neil Berryman
IT Trainer
neil_berryman@btopenworld.com