I have a combobox with:
Both
Left
No
Right
Based on the choice of the user, the combobox will enable lots of fields for the user to continue to answer. My problem is that "Both", "Left" and "right" all enable the same fields and my code:
Private Sub Proc_iliac_afterupdate()
Select case me.Proc_iliac.value
Case "both"
For each Ctl in me.controls
if ctl.tag = "proc_iliac" then
ctl.enabled = True
End if
Next ctl
Case "left"
For each Ctl in me.controls
if ctl.tag = "proc_iliac" then
ctl.enabled = True
End if
Next ctl
Case "right"
For each Ctl in me.controls
if ctl.tag = "proc_iliac" then
ctl.enabled = True
End if
Next ctl
End select
End sub
Comes up as an error when I try to pick one of the combobox choices. Please help, I don't know what I am doing wrong.
Both
Left
No
Right
Based on the choice of the user, the combobox will enable lots of fields for the user to continue to answer. My problem is that "Both", "Left" and "right" all enable the same fields and my code:
Private Sub Proc_iliac_afterupdate()
Select case me.Proc_iliac.value
Case "both"
For each Ctl in me.controls
if ctl.tag = "proc_iliac" then
ctl.enabled = True
End if
Next ctl
Case "left"
For each Ctl in me.controls
if ctl.tag = "proc_iliac" then
ctl.enabled = True
End if
Next ctl
Case "right"
For each Ctl in me.controls
if ctl.tag = "proc_iliac" then
ctl.enabled = True
End if
Next ctl
End select
End sub
Comes up as an error when I try to pick one of the combobox choices. Please help, I don't know what I am doing wrong.