Strike_Eagle
Registered User.
- Local time
- Today, 12:30
- Joined
- Oct 20, 2011
- Messages
- 48
Hello,
I have a problem with enabling one of two list boxes based on a combo box selection. Names of each element are:
Combo Box:
rdlSpecialist (assigned value of 1)
rdlSupervisor (assigned value of 2)
List Box:
SpecialistSelect
Supervisor_Name
rdlSpecialist enables SpecialistSelect and rdlSupervisor enables Supervisor_Name. Of course, whichever is enabled, the other should be disabled.
I have tried a multitude of varieties of code that I could think of and found online, and all located on the After Event [Event Procedure]. None get me the desired result, or even partially work for that matter. I am using Access 2007 on a Windows XP system.
A sampling of my latest rendition of code is:
Private Sub SupervisorSpecialistSelectFrame_AfterUpdate()
If Me.rdlSpecialist = 1 Then
SpecialistSelect.Enable
Else
Supervisor_Name.Enable
End If
End Sub
Thank you greatly in advance. I have been parusing this site on and off for years, but have never have come accross a prolem I couldn't figure out within a reasonable amount of time before. I hope I asked my question clearly, and please interrogate me for as much information as you need.
Strike_Eagle
I have a problem with enabling one of two list boxes based on a combo box selection. Names of each element are:
Combo Box:
rdlSpecialist (assigned value of 1)
rdlSupervisor (assigned value of 2)
List Box:
SpecialistSelect
Supervisor_Name
rdlSpecialist enables SpecialistSelect and rdlSupervisor enables Supervisor_Name. Of course, whichever is enabled, the other should be disabled.
I have tried a multitude of varieties of code that I could think of and found online, and all located on the After Event [Event Procedure]. None get me the desired result, or even partially work for that matter. I am using Access 2007 on a Windows XP system.
A sampling of my latest rendition of code is:
Private Sub SupervisorSpecialistSelectFrame_AfterUpdate()
If Me.rdlSpecialist = 1 Then
SpecialistSelect.Enable
Else
Supervisor_Name.Enable
End If
End Sub
Thank you greatly in advance. I have been parusing this site on and off for years, but have never have come accross a prolem I couldn't figure out within a reasonable amount of time before. I hope I asked my question clearly, and please interrogate me for as much information as you need.
Strike_Eagle