Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    9

    Answered: Activate Option Buttons through code

    I have a form for testing product that has many option buttons within option groups the option buttons are "Yes", "No" & "Intermittent".
    There are 20 or so option groups and at times a piece is tested and the answers to all of the questions is Yes. I'm looking for a way to click a button "Yes to All"
    and it changes all of the Yes option buttons to True. I can do it on individual buttons not within groups but am running into a brick wall when they're inside the option groups.

    Anyone have suggestions?

    Thanks

  2. Best Answer
    Posted by ranman256

    "you would run an update query to alter all the fields to YES, using that record key....

    quSetAllToYes: update myTable set [q1]='yes', [q2]='yes' where [ID]=forms!myForm!txtID"


  3. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    630
    Provided Answers: 35
    you would run an update query to alter all the fields to YES, using that record key....

    quSetAllToYes: update myTable set [q1]='yes', [q2]='yes' where [ID]=forms!myForm!txtID

  4. #3
    Join Date
    Nov 2005
    Posts
    9
    Thanks ranman256!

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
  •