Results 1 to 4 of 4
  1. #1
    IMACoolClassic is offline Novice
    Windows 7 32bit Access 2016
    Join Date
    Jul 2016
    Posts
    3

    Manage report sections based on list box selection


    I have a report that I created that has many subreports that are tied to test results.

    I also have a form that lists all the various tests for a user to select which tests they would like to see on their report.

    Currently the subreport sections are .visible=False on the report.

    I'd like to modify this based on the user selection so that select sections will be .visible=true and preview the report.

    Can someone steer for some VBA code that is able to make this happen on the on open event or other suggestions.

    Thanks.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,187
    put it in the query.
    bring in fields, sub1, sub2...
    all are set to true ,false....
    the report reads the fields and sets the subrpt to that value.

  3. #3
    IMACoolClassic is offline Novice
    Windows 7 32bit Access 2016
    Join Date
    Jul 2016
    Posts
    3
    thanks for the response ranman256.

    I'm not sure how I'd accomplish that with a query.

    I was finally able to get this functioning by having the report's on activate event read the form with the list box values and turn on the selectded subreports.

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,187
    How are you getting the true /false to hide your reports?
    a query can do it too.

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

Similar Threads

  1. Replies: 3
    Last Post: 05-06-2014, 10:17 AM
  2. Open Report based on list box selection
    By BorisGomel in forum Access
    Replies: 2
    Last Post: 04-17-2013, 02:41 PM
  3. Replies: 9
    Last Post: 10-16-2012, 07:51 AM
  4. Update table based on List Box selection
    By tpcervelo in forum Forms
    Replies: 0
    Last Post: 11-04-2010, 01:32 PM
  5. Replies: 2
    Last Post: 08-03-2010, 10:16 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