Printing mainform and selected subforms

[Keith Bemis]

Hello ,
I have access 2000 application with one main form that
users input patient names and other data including combo-
boxes, on the left of form are 6 buttons that user can
choose and enter data for whichever subform that should be
included for that patient type...I need to print the main
form and have only the subform selected print below the
main form one 1 page.. will this occur automatically when
the parent and child relationsips are created between the
forms? or is there more to it...thanks for any help....
Keith Bemis

 

[Jeff Boyce]

Keith

Forms in Access are typically designed for display on screen, and don't
necessarily look that good printed. If you need to print out the data you
have showing on a mainform and selected subform, consider using a report.

On your form, you can add a command button and the code to

DoCmd.OpenReport,,,...

with a filter for the main form record you want, and/or you could simply
open the report and have the report use the criteria from the main form (and
subform) via expressions referring back to these.