If statements to control visible parameters

[thatlemhome]

I have 3 combo boxes with selected reports that I want to display based on the types of filter variables selected.

I am attempting to control which list displays based on the selection in an option group "ReviewLevel."

Here is the code I am attempting to run. It seems to not recognize the last two of the three true/false statements for each option selection.

I have tried only having the true statement for each option, but if the user switches back and forth in selections, the combobox remains visible once on and does not revert back to invisible.

Any suggestions or another approach would be helpful.
Thanks

If Me.ReviewLevel = 1 Then
ComboGraphBox.Visible = True And ComboGraphBoxFU.Visible = False And ComboGraphBoxUOnly.Visible = False
ElseIf Me.ReviewLevel = 2 Then
ComboGraphBox.Visible = False And ComboGraphBoxFU.Visible = True And ComboGraphBoxUOnly.Visible = False
ElseIf Me.ReviewLevel = 3 Then
ComboGraphBox.Visible = False And ComboGraphBoxFU.Visible = False And ComboGraphBoxUOnly.Visible = True
End If

 

[RuralGuy]

It is your syntax. Try:

If Me.ReviewLevel = 1 Then
   ComboGraphBox.Visible = True
   ComboGraphBoxFU.Visible = False
   ComboGraphBoxUOnly.Visible = False
ElseIf Me.ReviewLevel = 2 Then
   ComboGraphBox.Visible = False
   ComboGraphBoxFU.Visible = True
   ComboGraphBoxUOnly.Visible = False
ElseIf Me.ReviewLevel = 3 Then
   ComboGraphBox.Visible = False
   ComboGraphBoxFU.Visible = False
   ComboGraphBoxUOnly.Visible = True
End If

 

[thatlemhome]

to simply!!!!!

Works great
Thank!

 

[RuralGuy]

Glad I could help.