Pass argument to a report from VBA?

[degras]

I have a report that I run from a command button with the following VBA:

DoCmd.OpenReport "Invoices", acViewPreview, , ""

The report has a parameter / argument called [Invoice No]. Is it possible to pass in the parameter (based on the current record) or should I get rid of the parameter and use the reports where clause instead?

Also I would like to go straight to printing report rather than going to a print preview screen.

[SoftwareMatters]

If you are always going to open the report from the screen where the parameter is set then you don't need to worry about using the where clause.

To go straight to print use acViewNormal

[pbaldy]

Here's one way to restrict a report to a particular record:

BaldyWeb wherecondition