Event Procedure for textbox visible

[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?

 

[Guest]

Place your code in the AfterUpdate event of the combo box control.

 

[Rock]

Place your code in the AfterUpdate event of the combo box control.

--
HTH

Mr B
askdoctoraccess dot com








- Show quoted text -

Perfect...Thanks!

 

[Guest]

Your welcome.

Good luck with your project.

Mr B
askdoctoraccess dot com