Criteria in report (Access 2000)

How could I open a report choosing criteria in the OnOpen event? I want to build a report with options from the form with the following criteria

1. orderby Delta , in descending and ascending order
2. to show only products where grossprice = 0
3. to arrange the products for the category 10, 11 and 12
4. to arrange the products for the category 1

Re: Criteria in report (Access 2000)

The examples from the MSKB articles and the sample database can easily be adapted for use with a form. Instead of DoCmd.OpenReport you'd use DoCmd.OpenForm (you'll have to modify the arguments slightly) and instead of Reports!... you'd use Forms!...
Finally, in the On Close event, you'd use acForm instead of acReport.