Results 1 to 3 of 3
  1. #1
    smith.jr is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2014
    Posts
    9

    Suppress subreport footer based on field value in main report

    I have a subreport with a group footer. Based on the value of a field in the main report, I want to make the subreport group footer visible or not visible. I'm using Access 2013 with Windows 10.

    I've read several post on this site as well as other and am not having any success.



    Thanks in advance for any help.

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Maybe this in the subreport OnFormat event in Detail section? Change MainReportField to point to your report field.

    If MainReportField = "A" Then
    GroupFooter.Visible = True
    Else
    GroupFooter.Visible = False
    End If

  3. #3
    smith.jr is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jan 2014
    Posts
    9
    Thanks so much for your help. I ended up putting the MainReportField in the header on the subreport. In the OnFormat event in the GroupFooter I used the following:


    If Me.[Certificate Title] = "My Text" Then
    Me.GroupFooter0.Visible = False
    Else
    Me.GroupFooter0.Visible = True
    End If

    Worked perfect!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 03-31-2015, 03:32 AM
  2. Replies: 1
    Last Post: 08-15-2013, 05:43 PM
  3. Replies: 1
    Last Post: 04-15-2013, 10:02 AM
  4. Subreport with criteria from main report
    By Evilferret in forum Reports
    Replies: 1
    Last Post: 08-15-2012, 03:19 PM
  5. Replies: 3
    Last Post: 06-15-2012, 11:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums