How to print a report of the current record ur on in a form.

[kassem]

Hi,

so i created a report called EstimatesR which creates a report for a form called EstimatesF which is linked to a table called EstimatesT. Can someone help me with a code that prints the report of the current form your on without the user seeing the report thats opens.



Thanks.

[ranman256]

If you mean, print the report of the current record on the form....then
DoCmd.openreport "EstimatesR", acViewPreview, , "[id]=" & Me.[ID]

this will report only the 1 record on the form. (use your own ID fields).

[kassem]

Yes this opens the report, how do i print it though, i want this to happen all at once.

[ItsMe]

Replace acViewPreview with acViewNormal