Code in Form

D

Dennis

I have a Form that when I choose one of four possible
codes in, [TB Code] a combo box using a value list, I
would like to change the value of another field [CXL]
which is a Yes/No radio button from "Null" to "No".

I not only want the value in the table to be "No"
not "Null", I want the radio button to be clear/all white
letting the user working of the form know the new
information. In the form, although the default of the
table field [CXR] is "No", the Form radio button's default
is grey/Null. This works for me but,

1) Why?

and

2)I am new at code. This is my first solo try. The code
does not seem to work and maybe someone can tell me why
and what to do to make it work or even make it better.
This in an Event Procedure in the "On Change" field of the
properties.

Private Sub Combo123_Change()
If [TB Code] = 21 Then
[CXR] = False

ElseIf [TB Code] = 32 Then
[CXR] = False

ElseIf [TB Code] = 33 Then
[CXR] = False

ElseIf [TB Code] = 34 Then
[CXR] = False

Else
[TB Code] = Null

End If


End Sub

I do not get any errors SUPRISE! But it does not seem to
work.

Thanks,

Dennis
 
Top