Results 1 to 6 of 6
  1. #1
    smg is offline Competent Performer
    Windows XP Access 2010 64bit
    Join Date
    Apr 2019
    Posts
    121

    convert subform with combo boxes to list of all and answer yes or no


    I have a database that has drop down combo boxes where users choose from different categories and then choose from the behaviors associated with that category. I am thinking about making it easier for users since they have to respond to each to change the form so that all the categories and their associated behaviors are listed and they just have to select yes or no or n/a for each. I am not sure how to do this. I am looking for suggestions. File attached with a pic of what the form and subform currently look like and a mock list of categories and behaviors below the form. There are a total of 40 behaviors.
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    This is a common topic. Solution is not simple. Be aware that having a yes/no field in table for user selection of records will cause conflict between multiple simultaneous users.

    Review https://stackoverflow.com/questions/...ith-checkboxes
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    smg is offline Competent Performer
    Windows XP Access 2010 64bit
    Join Date
    Apr 2019
    Posts
    121
    I have done very little in VBA so this looks a bit daunting to me. Is this a continuous form with a check box? It looks like I have to tie the check box to the detail record ID. Can I do that without writing code?

  4. #4
    smg is offline Competent Performer
    Windows XP Access 2010 64bit
    Join Date
    Apr 2019
    Posts
    121
    I mean using events instead

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Can have a yes/no field in table but has risk as already described. Otherwise, need code.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    Does Each Category have a specific List of Behaviour's ??
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

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

Similar Threads

  1. List box update from combo boxes
    By cpullen91 in forum Forms
    Replies: 4
    Last Post: 05-23-2016, 04:31 AM
  2. Replies: 1
    Last Post: 03-19-2016, 03:56 AM
  3. need help with Combo/List Boxes
    By SSUTTON in forum Forms
    Replies: 7
    Last Post: 04-01-2015, 11:12 AM
  4. Cascading Combo / List Boxes
    By plowe in forum Programming
    Replies: 5
    Last Post: 09-07-2012, 10:55 AM
  5. Combo/List Boxes
    By refryguy in forum Forms
    Replies: 3
    Last Post: 07-28-2011, 01:34 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