Printing Single Record

[fabian2405]

Dear All,

I am relatively new to ACCESS.


I was doing a report form and have managed to create table and the form.
Now, when I do a report and try to print, it prints all the RECORDS.

Could someone help to print an individual report based on the ID.

[orange]

See this vba reference. You must identify the record or records you want to report, otherwise all records are reported.

[Welshgasman]

So if you do not tell Access which record you want to print in the report, how is it supposed to know?

[mike60smart]

Hi Fabian

If your Form is set as Single Form then you need to go into Design View of the Form

Then add a Command Button in the Header.

Then in the On Click Event of the Button you would need something along the lines of:-

 If Me.Dirty Then Me.Dirty = False

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