Print all records in a report from a form generated from a query

D

Dennis

How do I print all records from a form generated by a
query in a report. When I do this now only one record
prints in the report. This is the line of code I am
using in the query that I use to run the report. [Forms]!
[Add Part frm].[Equip code]
 
R

rowiga

You're applying a filter to the report by using the line of code referencing
the current record on the form. Remove the reference to the form field to get
all records. If no filter is currently applied to the report you can do this
by using code similar to this in a command button's OnClick evenT:

DoCmd.OpenReport "YourReportName", acPreview
 
Top