[AccessD] How to print a report?

philippe pons phpons at gmail.com
Tue Jul 10 08:48:51 CDT 2007


Hi all,

I tried to print a report, but unsuccessfully till now!

I need to print the report but prior to this I set it'sFilter property:
    Report_BULLETIN.Filter = "COLL_ID=" & Me.cboSelColl.Value
    Report_BULLETIN.FilterOn = True

I discover I have to open the report and then set the Filter and FilterOn
property.
All  is ok, I can see my filtered report.

Now I want to print it.
I user
DoCmd.OpenReport "BULLETIN", acViewPreview
Report_BULLETIN.Filter = "COLL_ID=" & Me.cboSelColl.Value
Report_BULLETIN.FilterOn = True
DoCmd.OpenReport sNomEtat, acViewNormal

The report is printed with the correct number of records, but it remains
open in design view!!

What is the correct way of doing that?

Regards, Philippe



More information about the AccessD mailing list