Referencing A Reports RecordSource

[TarBall]

I am fairly new to Access and VBA.

How do I reference a Reports RecordSouce? I have a form which contains a few combo boxes/check boxes on it. I want to use the form to allow me to filter the output of a report. On the form, I also want to be able to create the report without selections from the combo boxes/check boxes. How do I do this?

I have figured out that I can specifiy a filter on the docmd.openreport method. I dont know how to refer to the reports RecordSource property to set the report to include all records? How do I do this?

thanks

 

[Pat Hartman]

Use the Where argument of the OpenReport Method rather than modifying the report's recordSource.