Results 1 to 3 of 3
  1. #1
    prsnx is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2018
    Posts
    1

    Question Report only for "selected" checkboxes rows

    Can I create a "report", which shows only for "selected checkboxes" rows
    In the "table" and the "query" can be filtered, but I want to make a "report", which filtered only for those selected boxes. I dont know how to do it


    At the moment "report" gives me also those "not selected" obtions that I dont want to.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    sounds like your 'selected' control is unbound - so it will be the same for all records.

    clicking the 'selected' control could trigger an event that populates a temporary local table with the PK of the selected record. You can then join your report table to this temporary table.

    Alternatively you could have a 'selected' field in your report table however I don't recommend this - in a multi user environment this could lead to confusion if two people are trying to run a report at the same time.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Select * from table where [checkFld]=true

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

Similar Threads

  1. Replies: 1
    Last Post: 09-29-2016, 03:12 AM
  2. Replies: 3
    Last Post: 08-05-2016, 12:59 PM
  3. Replies: 2
    Last Post: 04-12-2016, 12:58 PM
  4. Replies: 3
    Last Post: 04-22-2013, 06:08 AM
  5. Replies: 2
    Last Post: 08-31-2006, 12:19 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