Print a report with a single record

[TOPSie]

I have a (fortunately) small table (43 records). I have produced a simple report using fields just in this table.
If I do
DoCmd OpenReport, "MyReport",acPreview,,Me.Keyfield then the report appears as a single page on my screen with all the relevant boxes pertaining to the record indexed by KeyField
But this does not go to the printer.

If I change the acPreview to acNormal (or just default it) then 43 pages go off to the printer!!!



I am running out of paper - I only want a single sheet

[TOPSie]

I think I have answered my own question:

It looks like the WHERE clause is parsed more exactly when in acNormal mode. It looks like the parsing is more lax in acPreview (or is it something else)

anyway my WHERE clause for acPreview was something like - DriverId = me.DriverId and this seemed to produce jsut a single page on the screen (but were there more behind???)

in acNormal mode I had to do the WHERE clause properly "DriverId = " & me.DriverId - then just a single page is printed!!!!

[Micron]

Opening a report in preview doesn't print it. acNormal sends it to the printer. That will likely send the print job before any filtering could be applied. What might be more pertinent is that the latter syntax is the correct way. That the other syntax worked in preview was happenstance, I'd say. IMO the main objective with this process would normally be to open the report filtered, then send it to the printer but via code steps, not acNormal. If you don't want to see the report you open it hidden.

[mike60smart]

Hi

Your Command Button on the Form should have the following OnClick Event:-

Private Sub PrintButtonName_Click()

If Me.Dirty Then Me.Dirty = False

DoCmd.OpenReport "ReportName", acPreview, , "[DriverID]=" & me.DriverID

End Sub