Print report of current data on form

[AccessQuestion]

Not sure how to word this as I am somewhat new to Access 2007. What I am trying to do is the user fills out a form, when he hits the "save record" button I want it to save the record and print a report based on the information that was just entered. It is actually going to print a 4x6 label to use on a container. That label will contain the info that the user just filled out on the form so I need to format the report to fit on the label. Does that make sense? I know I can create a report after the fact, but I need to do it this way. I know the answer is out on google, but correctly searching is hard since I am not sure how to ask it. Thanks for any help you can give me.

[missinglinq]

@AccessQuestion
You simply design your report then call it limiting the data to the current record. Allen Browne has a nice little tutorial on the subject here:

http://allenbrowne.com/casu-15.html

Welcome to Bytes!

Linq ;0)>

[AccessQuestion]

Hey Linq, thanks for the reply. Thanks for the link. It may provide an easier way of doing it. I solved it by creating the report from a query in which I pass the Where data to the query from the form. Seemed like a hard way to do it so maybe Allen has a better way. Thanks for the reply!! I appreciate it.

[aerohunter]

Hi,

I hope someone can still help me here with this old post.
I did the above solution and I have the report printing work fine, but my problem is that the printing of report takes longer that I like. I think my problem is that I have a very large amount of records in the table/query to filter before printing.

I am hoping there is a way to just print the records in the form which is already filtered without running the query. Is there a way to send the records in the form to a temporary table/query for printing.

I have tried limiting the query with dates with little affect on the printing time.



TIA