View Full Version : Print report w/ filter ????


DblDogDare
03-27-2003, 05:31 AM
Although this is my first post, I have gained a tremendous amount of information from this forum. It has helped me a great deal.
I am trying to print a report utilizing a command button on a form. The form opens with a [type] command based on a query(A)of a "particular field" so that it filters to a specific record. I then have a command button to print a report of that specific recordset. The report is based on a different filter query(B). So, I have to type the "particular field" again to filter the report. If I point the report to the same query as the form, I still have to enter the "particular field" because it is a [type] command to open. I want to be able to print the recorset information that is on the current form without having to enter the parameter again. Any thoughts are greatly appreciated.

KevinM
03-27-2003, 06:58 AM
If you have been gaining info from this forum like you say you have then no doubt you would of come across this problem.

It has been asked (and answered) on numerous occaisons.

I would say at least every day for the past few weeks.

DblDogDare
03-27-2003, 07:10 AM
Thanks for the reply. While I have been searching these threads, and have gained a lot of knowledge from these threads, I have not come across the proper answer. Maybe I am using the wrong search criteria (filter, report, type). If you can point me to the thread it would be appreciated.
I have found a lot of threads that filter to print. The difference in my reguest is the Like[type] in my query that opens the form. The problem is the print button on said form requests the [type] again. I want it to print the report based on the filter already requested instead of having to request it a second time.

DblDogDare
03-27-2003, 11:21 AM
I did a little more digging in this forum and found the answer to my problem. I found it in tje queries section. For those that may be reading this thread and have the same problem, here is the link to the thread that I used .

Thanks everyone,
http://www.access-programmers.co.uk/forums/showthread.php?threadid=13336&highlight=Like+Type+print+report