D
DavisGail
I am working in Access 2003. I have a form that has an option group with 4
possible status codes ( 1 - 4). The status codes are basically, 1:
Qualified and 2 -4 are different ways of being not qualified.
I have another field on the same form that is for the reason code for the
NOT qualified.
If the student is qualified (1) is chosen I want the not qualified code to
be 0. Otherwise I want it blank.
I put some code in the AfterUpdate of the option group:
If Me.ScreeningStatus.Value = 1 Then
Me.NotQualCode = 0
Else
Me.NotQualCode = " "
End If
This works okay, but if I click qualified (1) in error, and then click the
correct code (say 2), the 0 stays in the NotQualCode. How do I clear it?
possible status codes ( 1 - 4). The status codes are basically, 1:
Qualified and 2 -4 are different ways of being not qualified.
I have another field on the same form that is for the reason code for the
NOT qualified.
If the student is qualified (1) is chosen I want the not qualified code to
be 0. Otherwise I want it blank.
I put some code in the AfterUpdate of the option group:
If Me.ScreeningStatus.Value = 1 Then
Me.NotQualCode = 0
Else
Me.NotQualCode = " "
End If
This works okay, but if I click qualified (1) in error, and then click the
correct code (say 2), the 0 stays in the NotQualCode. How do I clear it?