Main-Form/Sub-Form Printing

[saip15]

Hi everyone,

So I have a Mainform without page/form headers and footers and a Subform. The Subform is in datasheet view which works well since it's a table were users can add revisions so the table can grow. Everything prints just fine but I run into problems when the datasheet becomes larger than Subform window. Here's what it looks like, which looks very close to what i want.

Is there anyway to lock the bottom of the subform of where it cuts down to the next page? I want to set how the Subform prints. Which is not the same as the subform border.

 

[pbaldy]

Printing forms is problematic. You'd be better served by creating a report/subreport that presented the data like you want, and print that.

 

[SOS]

Printing forms is problematic. You'd be better served by creating a report/subreport that presented the data like you want, and print that.

A BIG AMEN to that! Reports are the way to go. Forms are very limited in what you can do as far as printing.

 

[saip15]

But if the user is entering data I don't want them to jump over to the Reports tab to be able to print, and have to select which record they want printed. It would be easier for them to just print the current form they were entering and move on to the next form.

 

[pbaldy]

Use this technique to print the report for the currently displayed record:

http://www.baldyweb.com/wherecondition.htm