Results 1 to 2 of 2

showing certain values on report

  1. #1
    rehanemis is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2019
    Posts
    1

    showing certain values on report

    Hi,



    I would like to know is there a way to include the fields where user checked the check-boxes. For example: I have form which showing 20 options with check-box value to Yes or No. I want to include only the options where user marked the check-box to Yes. Is there way to only show that fields where user marked yes?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,804
    this is the downside of option box (check boxes) , they ALL must be programmed.
    If you add / subract an option, the form must be reprogrammed.
    Tho you can reference anything on the form with the full path: forms!myForm!chkBox

    alternate ways:
    1. a query can pull the options:
    select forms!myForm!chBox1 as IsSmoker, forms!myForm!chkBox2 as HasInsurance from table

    2. Dont use checkboxes/optons, instead use a listbox for users to select items in it with a dbl-click.
    the dbl-click runs an append query to add the value to a table (tPicked).
    SMOKER
    HAS INSURANCE
    GLASSES

    This way you only work with VALUES and don't need to reprogram for new values, you simply add a new value to the source table.

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

Similar Threads

  1. Replies: 9
    Last Post: 08-08-2016, 02:57 PM
  2. Replies: 7
    Last Post: 04-02-2015, 07:25 AM
  3. Replies: 15
    Last Post: 04-16-2014, 01:15 PM
  4. Replies: 2
    Last Post: 01-02-2014, 02:33 PM
  5. Sql query not showing all the values
    By usr123 in forum Access
    Replies: 0
    Last Post: 02-24-2010, 07:32 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
  •  
Tech Forums: Microsoft Office Forums