sub for record change?

[mshmyob]

You are welcome........ .............

thanks mshmyob :) thats exactly what I needed.

[zivon]

thanks mshmyob :) thats exactly what I needed.

[mshmyob]

Put it in the ON CURRENT event instead.

is there a way to excute a command on record change ?

I used form_load to check something, but when I go to the next/previews record it doesn't recheck..

Private Sub Form_Load()
    If RefBy.Value = "test" Then
        ReferredID.Enabled = True
   End If 
End Sub

[zivon]

is there a way to excute a command on record change ?

I used form_load to check something, but when I go to the next/previews record it doesn't recheck..

Private Sub Form_Load()
    If RefBy.Value = "test" Then
        ReferredID.Enabled = True
   End If 
End Sub