Access 2010 Report does not have Focus

[MacroAlan]

I'm building a report using a temp table to hold the data. The report looks great. The problem comes when the user tries to print and even though the report is selected and on top of the control form, the form is printed and not the report.

Could the problem be in my code?

   DoCmd.OpenReport "rptScrapReport", acViewPreview

   DoCmd.SelectObject acReport, "rptScrapReport"

Can I tell the form to lose focus?


Alan

 

[dhookom]

How is the user trying to print? Can't they just click the Print icon on the ribbon?

Duane
Hook'D on Access
MS Access MVP

 

[MacroAlan]

That is what they try to do but it prints the Form


Alan

 

[dhookom]

I have never had that happen. When I open a report in Print Preview and then click the printer icon, it always prints the report and never the form. By any chance is your form opened in dialog mode? Is there any code in your report?

Duane
Hook'D on Access
MS Access MVP