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

    Yes or No selected on form drives next control

    I have a yes/no checkbox in a subform. If a user checks the checkbox, I want to disable the next control so they are unable to select from it's multi-select combo box, called Error Precursors. If the user does not check the checkbox I want them to have to select from it's multi-select combo box. Is this something I can do with validation rules?
    Attached is my db, please see the frmBehaviorsSubform.
    Attached Files Attached Files

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    The disabling I'd do with this type of thing:

    http://www.baldyweb.com/ConditionalVisibility.htm


    I don't think the validation can be done with a rule. I'd have code in the before update event:

    http://www.baldyweb.com/BeforeUpdate.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    smg is offline Competent Performer
    Windows XP Access 2010 64bit
    Join Date
    Apr 2019
    Posts
    121
    I am having trouble making this work, would you be able to show me how to accomplish this in the database I attached to my initial post on this subject?

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Why don't you post an updated database with your efforts and we'll fix it?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Control not reflecting the selected format
    By George in forum Modules
    Replies: 2
    Last Post: 06-24-2016, 01:58 PM
  2. Replies: 5
    Last Post: 04-15-2015, 04:20 PM
  3. Record Source is being Corrupted that drives Form
    By CementCarver in forum Forms
    Replies: 16
    Last Post: 08-01-2013, 01:10 PM
  4. Replies: 3
    Last Post: 07-31-2013, 08:30 AM
  5. Access and NAS drives
    By ekkg in forum Access
    Replies: 1
    Last Post: 07-06-2012, 08:30 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
  •  
Other Forums: Microsoft Office Forums