Printing wrong Form / Report

[philb316]

I just joined this Forum so apologies if this is an old question:

Access 2010;

I have a typical form for user input which, from a button on the form, fires up a report in Print Preview. When I then try to print the Report (just using the standard Print Icon in Access), it prints the Input Form rather than the Report, eventhough the Report has the focus.

When I close the form so that the only window open is the Report, then the Access Print Icon grays out.

Thanks for any help.

 

[Simon_MT]

You have to Print a Report this does a preview first:

DoCmd.OpenReport "Originals Report", acViewPreview, "", "[Orig Artist Ref]='" & .[Artist] & "' And [Orig Stock Status]='C'", acWindowNormal

Simon

 

[philb316]

I'm using this code from the form:
DoCmd.OpenReport "RPT11AwCover1", acViewPreview, , , acWindowNormal

i have determined that the only way to print the report is to change to Report View, then use the standard Print Icon, otherwise the form gets printed. Weird, but true.