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