R
Rock
Good morning...I have the following code that works fine as I go from
one record to the next:
Private Sub Form_Current()
If IncName.Value = "Car Allowance" Then
caMileage.Visible = True
Else: caMileage.Visible = False
End If
IncName is a combo box and caMileage is a textbox. What I'm trying to
do now, seems easy, but I'm stumped. When I add a new record and
select 'car allowance' from the drop down, nothing happens, meaning
the caMileage textbox does not change to visible.
I've copied this code to other event procedures, but nothing seems to
be working, I get the same result which is no textbox. I've tried
AfterUpdate, BeforeUpdate, GotFocus...and others from the Form's
properties. I've tried the other On...Events from the field it
self...any suggestions?
one record to the next:
Private Sub Form_Current()
If IncName.Value = "Car Allowance" Then
caMileage.Visible = True
Else: caMileage.Visible = False
End If
IncName is a combo box and caMileage is a textbox. What I'm trying to
do now, seems easy, but I'm stumped. When I add a new record and
select 'car allowance' from the drop down, nothing happens, meaning
the caMileage textbox does not change to visible.
I've copied this code to other event procedures, but nothing seems to
be working, I get the same result which is no textbox. I've tried
AfterUpdate, BeforeUpdate, GotFocus...and others from the Form's
properties. I've tried the other On...Events from the field it
self...any suggestions?