Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    printing only a subform (2002 SP3)

    This is probably a silly question, but how do you get a subform only to print without the parent form printing? Printout only prints the whole lot, parent & subform. I tried setting focus to the subform before printing, but it made no diff.
    Regards,
    Peter

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: printing only a subform (2002 SP3)

    You don't. Subforms exist only as controls on the parent form, so it is like trying to print one control on the parent form. Forms aren't ideal for printing anyhow, in spite of what the product implies.
    Charlotte

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: printing only a subform (2002 SP3)

    In addition to what Charlotte wrote, I'd suggest to create a report based on the same record source as the subform. You can put a command button on the main form or on the subform to open the report. You can pass a where-condition based on the current record in the main form (and subform, if needed) in DoCmd.OpenReport.

  4. #4
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: printing only a subform (2002 SP3)

    Thanks Charlotte
    Regards,
    Peter

  5. #5
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: printing only a subform (2002 SP3)

    Thanks Hans (again).
    I was hoping that I wouldn't have to do that. But it didn't take long and it works just fine.
    Regards,
    Peter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •