Trying to set multiple text box properties

[SgtSaunders69]

I want to set the properties of various combinations of text boxes based on what the user selects in a combo pulldown box. The code I have will only make the changes in the first section for the first report listed "All currently open work requests". ... After that nothing runs... no errors.. just doesn't do anything.


Private Sub Combo21_AfterUpdate()
If Forms![FRMrpt1]!Combo21! = "All currently open work requests" Then
Forms![FRMrpt1]!Combo19.Enabled = no
Forms![FRMrpt1]!Combo26.Enabled = no
Forms![FRMrpt1]!Combo28.Enabled = no
Else
Forms![FRMrpt1]!Combo19.Enabled = yes
Forms![FRMrpt1]!Combo26.Enabled = yes
Forms![FRMrpt1]!Combo28.Enabled = yes

End If
If Forms![FRMrpt1]!Combo21! = "All Excalated work requests - Closed" Then
Forms![FRMrpt1]!Combo19.Enabled = yes
Forms![FRMrpt1]!Combo26.Enabled = yes
Forms![FRMrpt1]!Combo28.Enabled = no
Else
Forms![FRMrpt1]!Combo19.Enabled = no
Forms![FRMrpt1]!Combo26.Enabled = no
Forms![FRMrpt1]!Combo28.Enabled = no


End If

End Sub

Any thoughts would be appreciated!

Usinig MSAccess 2010

 

[Addyman]

The code I have will only make the changes in the first section for the first report listed "All currently open work requests"

Could you please explain a little further? Do you mean it will only change the property of the first combo box listed in the code? I'm a little confused as to what is happening or what you are expecting to happen.

 

[SgtSaunders69]

I got a solution to this.. if you read down the thread...

 

[Addyman]

I've read down the thread. I'm confused. If you have a solution, why post the question?