Results 1 to 4 of 4
  1. #1
    scoutwes is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2018
    Posts
    4

    Checkbox True/False based on Dropdown Selection

    I have a drop down combo box on a form with three possible options,photo, video, and graphics.




    I want to make a checkbox for each of those options shows up on a report only if its corresponding value is chosen, otherwise remain hidden.


    I've been searching for a couple of days and had no luck.

    Can anyone help?

  2. #2
    John_G is offline VIP
    Windows 10 Access 2016
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    I want to make a checkbox for each of those options shows up on a report only if its corresponding value is chosen, otherwise remain hidden.
    Is the combo box selection being stored to a table? If not, how is the report going to be able to "know" what the selection was?

    Bu why would you want a checkbox that essentially duplicates what the combo selection was? Why not just report the combo selection value?

  3. #3
    scoutwes is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2018
    Posts
    4
    Quote Originally Posted by John_G View Post
    Is the combo box selection being stored to a table? If not, how is the report going to be able to "know" what the selection was?

    Bu why would you want a checkbox that essentially duplicates what the combo selection was? Why not just report the combo selection value?
    Yes, the selection from that box is being stored in a table. I'm open to other ways to accomplish this task if you have an idea. But the report I'm printing is based on an existing document that I'm overlaying the inputs from the database onto to complete it. In this case, the dropdown is a selection of a checkbox on the document. While I could just create a checkbox for each option as the simplest route, the dropdown is much cleaner looking!

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    perhaps an option box will do what you require - they work using an incrementing number, 1,2 3 so your combo rowsource will need to supply that number.

    be aware that for continuous forms visibility applies to all rows, it is not something that can be set conditionally for each record. And in any event checkboxes cannot be conditionally formatted.

    an option box will work in continuous forms, but if you were to add another option you would have to modify your form. So far as I am aware they are not filterable if that is going to be a requirement.

    further thought is to use a text box which using a wingdings character can be made to look like a checkbox. Again in a continuous form you cannot affect visibility conditionally, but you can conditionally set the forecolor to the backcolor which effectively hides it.

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

Similar Threads

  1. Replies: 8
    Last Post: 12-21-2016, 09:03 PM
  2. Replies: 1
    Last Post: 03-21-2016, 07:32 PM
  3. Replies: 8
    Last Post: 10-06-2014, 03:02 PM
  4. Replies: 7
    Last Post: 05-30-2013, 04:22 PM
  5. Replies: 4
    Last Post: 05-29-2013, 01:29 AM

Tags for this Thread

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