Help Print Command

[Janet]

I have a command button on my form to print a report. I
want to just print the current page of the report but it
keeps printing the whole thing.

Help

Thanks,
Janet

 

[Al Camp]

Janet,
I think you mean you're looking at ex. record 49 of 100... and you'd like
to just print the report for that record.

Let's say for example, your form name is frmMyForm, and you have a key
field on that form, ex... CustID.

In the query behind your report, in query design mode, in the CustID
column, put this Criteria...
=Forms!frmMyForm!CustID

Now whenever you run this report, it will look to the Open form CustID,
get the value, and filter out all other records but that one.

 

[Dale Fye]

Or,

if you are using DoCmd.OpenReport, there is a WHERE parameter that can
be passed to the report. Check this out in Access Help under
OpenReport.

--
HTH

Dale Fye


I have a command button on my form to print a report. I
want to just print the current page of the report but it
keeps printing the whole thing.

Help

Thanks,
Janet