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]
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print a report from a form based on a query 4
Access Access Report Works on One Machine but not Another 3
Creating a report for 1 record from a query 3
Can't create a report from my query in Access 1
Searching for Records in a Report 1
QUERY/REPORT 3
Print individual pages in a report 2
Create a button that prints the selected record of a report 4

Top