Print Report Record Matching Current Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form called FILE with a field in the Form called FileNum which is
stored in a table. On my form, I have a button to print a report. The
report is based on the table. When I click on that button, I only want to
print the report record that is equal to the FileNum and no other records.

Please help.

Thank you.
 
Use the Where Condition argument of the OpenReport method. It is the 4th
argument in the list. You can do something like this:

strDoc = "MyReportName"
strWhere = "[FileNum] = '" & Me.FileNum & "'"
DoCmd.OpenReport strDoc,,,strWhere
 
I have a form called FILE with a field in the Form called FileNum which is
stored in a table. On my form, I have a button to print a report. The
report is based on the table. When I click on that button, I only want to
print the report record that is equal to the FileNum and no other records.

Please help.

Thank you.
Click to expand...

It depends upon the datatype of the FileNum field.
If it is a number datatype:
DoCmd.OpenReport "ReportName",acViewPreview, , "[FileNum] = " &
[FileNum]

If it is a Text datatype, then use:

DoCmd.OpenReport "ReportName",acViewPreview, , "[FileNum] = '" &
[FileNum] & "'"
 
Back
Top