Hi all -
I am very new to Access so please forgive me if I am making some basic mistakes...
I want to make one field invisible based on the value of another field. Looking in these forums I found the following code (modified to my own field names & values):
Private Sub Form_Current()
If XYZ_1 = "T3"
Then
XYZ_36.Visible = False
Else
XYZ_36.Visible = True
End If
End Sub
Private Sub XYZ_Form_Change()
If XYZ_1 = "T3"
Then
XYZ_36.Visible = False
Else
XYZ_36.Visible = True
End If
End Sub
Which works fine except for one minor detail - it only works if one uses the mouse to select from the combo box list (attached to XYZ_1). If a user ignores the combo and physically types the value (T3) in, then the visibility of XYZ_36 does not change (and vice versa - if T3 is already selected and XYZ_36 is invisible accordingly - typing another value does not make it reappear).
Any help appreciated,
Thanks,
Rramjet.