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

    selection in yes/no checkbox requires input into next field in a form

    I have a form with a yes/no check box. If yes is not checked I want the user to have to have to pick something in the next field of the form and if they check yes, I want them to be unable to pick something in the next field of the form.How do I accomplish this?

  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,652
    I'd use both of these. The first would need to be adapted to check your first field, the second I might toggle the enabled property:

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

    http://www.baldyweb.com/ConditionalVisibility.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
    anyway to do this without coding?

  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,652
    I don't use macros, but you may be able to get one to work.
    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. Replies: 3
    Last Post: 04-10-2015, 10:26 PM
  2. Replies: 8
    Last Post: 06-05-2014, 12:08 PM
  3. compile a field on checkbox selection
    By jsabina in forum Forms
    Replies: 3
    Last Post: 01-06-2012, 01:12 PM
  4. Replies: 11
    Last Post: 12-25-2011, 04:33 PM
  5. Display Query Value That Requires Input Parameter
    By Access::Student in forum Access
    Replies: 1
    Last Post: 05-29-2009, 08:43 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