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.