Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    413

    Unanswered: Change Value of Option Group

    I have 2 Option Groups each with a control source. One is named Frame299 and it's control source set to List. It has 3 values List A List, B List and C List
    The other option group is named Frame242 with it's control source set to Status. It has 3 values also, Active Archived and Unavailable.


    If the user chooses to set the value on Frame299, i.e. List to List A (value 1) then I want the value of Frame242 i.e. Status to be set to Active or value 1.

    How can I do this?

    Thanks,

    Dave

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Love the names.

    In the after update event of Frame299:

    Code:
    If Me.Frame299 = 1 Then
      Me.Frame242 = 1
    End If
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •