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

  • Thread starter Thread starter Dennis
  • Start date Start date
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]
 
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
 
Back
Top