asked on

Report Printing many records but only need 1 at a time

Hi all I am back again with another problem. :) (Eye rolls everywhere) :)

I have created queries and built reports around those queries which I need to print. I have got it to a point where it is displaying the information but it is also displaying all the information for all the records. How can I get it to only print 1 record.

I have tried different things by using the WHERE statement and i have tried filtering and also tried recreating the report.

The reports that are required are in the following db

The reports are Test and TESTCS built on query1Test and queryTESTCS

Thanks for your help

John Tsioumpris

Take a look at my attachment...essentially you are pointing to which specific project you are referring...your main screen --> Print Reports
CoreQADev.zip

ASKER CERTIFIED SOLUTION

PatHartman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Allan Payne

ASKER

@John Tsioumpris

Thank you for your input. I tried both ways and i have found that Pat's vba code is much more versatile and can do what i want it to do.

@PatHartman

You my good sir have a remarkable brain. :) Thank you again.

John Tsioumpris

I have the exact same code....i can't understand what is the issue...?...have you even tried opening the attachment ...looking at the Print Report button and examining the code behind...?

Allan Payne

ASKER

Thank you Pat you are a brilliant mind in Access

PatHartman

You're welcome.