TheSearcher
Registered User.
- Local time
- Today, 04:39
- Joined
- Jul 21, 2011
- Messages
- 304
I have a form that contains an option group consisting of 5 option buttons. The option group is called opt_IncidentType.
On the form's Open event I run a query which opens a recordset containing the value from a field called Incident_Type.
This is my code:
The problem is that none of the option buttons is ever selected. Shouldn't assigning a value to the button (Me.opt_IncidentType.Value = 1) cause it to show as selected?
Thanks,
TS
On the form's Open event I run a query which opens a recordset containing the value from a field called Incident_Type.
This is my code:
Code:
Select Case rs("Incident_Type")
Case "Danielle's Law (911)"
Me.opt_IncidentType.Value = 1
Case "Transport to Hospital (Not 911)"
Me.opt_IncidentType.Value = 2
Case "Stephen Komnino's Law (abuse/neglect/exploitation)"
Me.opt_IncidentType.Value = 3
Case "Stephen Komnino's Law (moderate or major injury)"
Me.opt_IncidentType.Value = 4
Case Else
Me.opt_IncidentType.Value = 5
Me.txt_Other.Visible = True
Me.txt_Other.Value = rs("Incident_Type")
End Select
Thanks,
TS