Tab stop enabled if field yes. otherwise

[Guest]

I have a field called splitorder that if it is NOT checked off I want truck2#
field to not be enabled for tab stop. If it is checked off I would like it
to be enabled for input. It works for the first record but it enables it for
ALL of the records even if splitorder is or is not checked off. I have
attached this to the oncurrent event of the form and to the after update of
the split order field.

I have posted something similar to this before but has not been resolved.

Any ideas,
Barb

See below for present code


Private Sub Splitorder_AfterUpdate()
If Not IsNull(Me.Splitorder) Then
Me.Truck2.Enabled = True
Else
With Me.Truck2
..Value = ""
..Enabled = False
End With
End If

 

[Douglas J. Steele]

You need to put that same code into the form's Current event so that it
fires whenever you change from record to record.