Print Report

[Engineer Clement]

Hi,
kindly direct me on what to do
I have a form and a report.
On the form, I have a print button.
When I click the print button, I want it to print only my focus on the report. i.e if I am on serial no 4 on the form, in the report, it should print only content of serial no 4 and not every thing.
Thank U.

[puppydogbuddy]

Assuming that SerialNo is in a textbox control on your form named "txtSerialN o". You need to replace the object names that I used for illustrative purposes with their actual names in your application.

If serial no is a numeric datatype:

DoCmd.OpenReport "yourReportName", acViewPreview , , "[SerialNo] = " & Me!txtSerialNo

If serial no is a text datatype:

DoCmd.OpenReport "yourReportName", acViewPreview , , "[SerialNo] = '" & Me!txtSerialNo & "'"