Results 1 to 2 of 2
  1. #1
    shadowsedge is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2016
    Posts
    19

    How do I make Yes/no combo box dependent on another yes/no combo box


    I got 3 questions on a form but each is dependent on the previous.

    1st question: "Was there a high spot?" -> Yes (new question pops up) No(nothing happens)
    2nd question: "Was the high spot FOUND on the map?" (either = next question pops up)
    3rd question: "If the high spot was over 50, did you notify the developer? (ends here)

    What would be best for this series?
    I was thinking combo box or list box but since all 3 are yes/no questions, would a Boolean work?
    How do I make them dependent on the previous. (so if they answer no to the 1st, they can skip the next 2)

    Or is there a better way? (VBA illiterate here but working on it!)

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    maybe:
    the tQuestionTbl has
    [Q], [QIfY],[Ans], [Ans2]

    the question ,and a follow up if yes question.
    The form could only show 1 question at a time, since the QIfY would have to be invisible,
    if user clicks Y, then QifY is visible,
    Code:
     SUB Ans_afterupdate()
    If ans = "Y" and Not ISNULL(QifY)
       QifY.visible = true
       Ans2.visible  = true
    endif
    end sub
    'remember to reset for every question
    in the ON CURRENT event
    QifY.visible = false
    Ans2.visible = false

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

Similar Threads

  1. Replies: 2
    Last Post: 05-20-2014, 10:41 AM
  2. Dependent Combo Box Problem
    By JoshLewis in forum Forms
    Replies: 5
    Last Post: 04-04-2013, 01:19 AM
  3. A Combo Box Dependent to another Combo Box.
    By cap.zadi in forum Forms
    Replies: 2
    Last Post: 11-24-2012, 01:06 PM
  4. Dependent Combo Box
    By tigers in forum Forms
    Replies: 1
    Last Post: 06-16-2009, 12:46 PM
  5. Replies: 3
    Last Post: 02-26-2009, 10:17 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