Selective Printing

[Dr_Worm]

I have a form with a combo box linked to a field called Status. If I select the first option "Requires Approval" and click the print button it will print out an approval sheet. But if I select one of the other options it prints out a blank form (Report).

The report is based on a query with the criteria from the combo box.

What I want to do is make it so that nothing is printed at all if anything other that "Requires Approval" is selected in the combo box.

I'm sure it's a very simple peice of code.

Thanks

 

[bat17]

Two methods, the first is to use the "NoData Event" of the report to cancel it.
The second would be to add an if statement to the code behind the Print button and check the value of the combobox before printing.

HTH

Peter