Print data on forms

[jamz]

Hi everyone!



I hope everyone can help me with this. I have main form and sub-form( please see picture above), whenever I print those forms(main and sub), since my data in subform is around 500 records or rows, why is that the only first page will print, so instead of 500, only 20 to 30 records will print depends on the records fitted on a landscape A4 size paper.. Please help me, what is the problem with my work? thank you in advance.

[Minty]

Use a report. Forms are for data entry and display, reports are for printing.
Form printing is very limited in it's use, as you have discovered, it will literally render what is on screen.

On the report use the main form data as your header, and the sub form data as your detail lines.
Use the grouping functions on the report to get the desired layout.

[jamz]

Hi Minty, thank you for your reply. If ever I will use Report to print data, how can I easily find or search PCBA PN, I have tried that Report cannot use command button, is there other way to easily find PCBA PN instead of clicking next below button, because I think I have 200 PCBA PN's, It will be hard for the user to print out the specific PCBA PN by finding desired PN one by one..Hope you can help me please, thank you in advance.

[June7]

Code behind button on form opens report filtered to the value:

DoCmd.OpenReport "reportname", , , "[PCBA PN]='" & Me.[PCBA PN] & "'"

[jamz]

Hi June7, I think your idea is excellent. I tried the code, but I will put it on "Print" button instead of "Find button".. Beacuase I need to find first the PCBA PN that will be print out before I click the print button with the above code. Thank you very much