Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    I have a case where a subreport can execute the Detail_Format event as well as the OnLOad event when i run the subreport by itself.

    However when i include the subreport inside a main report the VBA code in the subreport is not executing.

    Any tricks i need to know about?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    It seems i need to set the Default View to Print Preview and not Report View.

    Now it goes thru the Detail Format event but not the OnLoad event of the subreport.

    Why is this so?

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    Found the reason, i had to put the code in the subreports OnOpen event and NOT the OnLoad event.

Posting Permissions

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