mraetrudeaujr
Technical User
This post relates to my previous post (thread702-1148781) where I needed to cause an 'option group' to return a YES or NO response depending on what value was selected in a combo box. I figured it out with the help of Xiciana, but now I've realized that this combo box should also trigger another 'option box' response, at the same time.
I have adjusted the table to include a fifth column with the appropriate information to 'call' from. So here is the previous code that is used on the "After Update" Event Procedure;
I thought that I could just add another 'If' statement directly below the "Me.optgrpSIRCountryPage2.Value = 1"
string; kind of like this;
However when I tested it, it performed the first operation, but didn't perform the second operation. What happened? I must be setting up the code out of order or wrong. Can anybody straighten out my code? Thank you.
I have adjusted the table to include a fifth column with the appropriate information to 'call' from. So here is the previous code that is used on the "After Update" Event Procedure;
Code:
Private Sub cboCountryPage2_AfterUpdate()
If Me.cboCountryPage2.Column(3) = 1 Then
Me.optgrpSIRCountryPage2.Value = 1
Else
Me.optgrpSIRCountryPage2.Value = 2
End If
End Sub
I thought that I could just add another 'If' statement directly below the "Me.optgrpSIRCountryPage2.Value = 1"
string; kind of like this;
Code:
Private Sub cboCountryPage2_AfterUpdate()
If Me.cboCountryPage2.Column(3) = 1 Then
Me.optgrpSIRCountryPage2.Value = 1
Else
Me.optgrpSIRCountryPage2.Value = 2
End If
If Me.cboCountryPage2.Column(4) = 1 Then
Me.optgrpOtherThanMexicanPage4.Value = 1
Else
Me.optgrpOtherThanMexicanPage4.Value = 2
End If
End Sub
However when I tested it, it performed the first operation, but didn't perform the second operation. What happened? I must be setting up the code out of order or wrong. Can anybody straighten out my code? Thank you.