printing one record.

MooG

New member
Local time
Yesterday, 18:56
Joined
Jun 11, 2012
Messages
9
i dont know how to set a filter to only come up with a current form.
i have tried the allen browne link; however it still prints all the pages when i switch acviewpreview, to acviewnormal. i also change the [id] with mine. Whoever fills out the form will want to print that page, and if they scroll back to any older record they will only want to print that record on a page.
 
i have typed in:

DoCmd.OpenReport "report1", , , "ROLL_FORM= " & Me.WORK_ORDER_ID

Report1 is the report i want to print, ROLL FORM is the form i type into and Work ORDER is the unique value im referencing. when i click my command button it prints all pages.
 
ROLL_FORM needs to be the name of the field in the report's source.
 
I want the form "ROLL FORM" to be what the report looks like, i had to delete some items to post but thats my entry form. Report1 is where it will go to print. PRINT_ID field under the table WORK ORDERS is always unique autogenerate number, or can also use WORK ORDER ID which is also unique. I am still a little confused on report source.
 

Attachments

Oh Ok that's what was confusing me, it was a subform i wasn't even thinking of that, i was just thinking if i put it into a report its a report... it all makes more sense thank you i will try the report printing as that sounds easier.
 
The report prints just fine now thanks again!
 

Users who are viewing this thread

Back
Top Bottom