Printout with subforms....

B

Bill Brinkworth

i have a form with 3 subforms on it.....two of the forms have more then one
record associated with them, although not showing at the time i would like to
"pirnt screen", when i issue:
''DoCmd.SelectObject acForm, "deposit", False
'DoCmd.SelectObject acForm, "Forms!deposit!Disbursements", True
'DoCmd.SelectObject acForm, "Forms!deposit!CashHistOrphans4Deposits", True
'DoCmd.SelectObject acForm, "Forms!deposit!Disbursements!Designated", True
'' DoCmd.PrintOut acSelection

' DoCmd.SelectObject acForm, "Deposit", True
'This prints out two copies of the report
DoCmd.PrintOut acSelection

the docmnd. printout prints out the forms and all the associated records
with the sub form. Instead of getting a snapshot of the complex form i am
getting multiple pages. the printout works fine on simple form. Has any one
tried this on a form with subforms and how did you get around it? as you can
see from the included code, i also tried the "'DoCmd.SelectObject acForm..."
command but couldn't get it to work

Thanks in advance for your time and help!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Switch between sub forms 4
Print Form with single record 1
Trying to Print "Client Receipt" form per client visit 2
Runtime error 2501 3
Going Crazy! Form Datasheet does not reflect changes to SQL query 4
One page limit via print macro 4
Problem printing form 4
Printing a Report on a command button 1

Top