Results 1 to 2 of 2
  1. #1
    joreid7 is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Aug 2017
    Posts
    1

    Insert subreport based on tick boxes

    Hi everyone

    I hope I can explain this correctly.

    I have created a database containing information about organisations, including what regions they operate in and what services they offer, these are selected by ways of a checkbox. Each organisation has their own organisational profile. What I am wanting to do is create a regional profile which shows only the organisational profile subreports if that region is checked and if "permission granted" is checked.



    Can anyone explain how I go about this please?

    P.S due to the sensitivity of the data I cannot post the database.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Checkboxes are not the way to go to add data. Data is the better data.
    youd have a table with all the possible items an org can have
    Permission granted,
    Pets allowed,
    etc

    then data can be added /removed put putting the record in a subTable.
    When the requirements change, you can add/remove them from the table.
    NOT so with checkboxes....
    you must manually add them to the forms everytime a new requirement is added/removed.
    now,
    if your requirements are not going to change, then checkboxes work.
    you can turn on the subreport if Permission is on,

    me.sub.visible = me.PermissionGranted.value

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

Similar Threads

  1. Aligning Tick Boxes With Labels
    By Chris Waller in forum Forms
    Replies: 8
    Last Post: 10-20-2014, 02:29 AM
  2. Replies: 9
    Last Post: 06-04-2014, 10:45 AM
  3. Tick Boxes = WHERE clause
    By dr4ke1990 in forum Forms
    Replies: 9
    Last Post: 11-08-2013, 12:03 PM
  4. Replies: 5
    Last Post: 05-05-2012, 10:11 AM
  5. Multi Based Criteria for SubReport
    By lostfan789 in forum Reports
    Replies: 1
    Last Post: 05-22-2010, 08:27 PM

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