sub for record change?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • zivon
    New Member
    • Aug 2007
    • 59

    sub for record change?

    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..

    Code:
    Private Sub Form_Load()
        If RefBy.Value = "test" Then
            ReferredID.Enabled = True
       End If 
    End Sub
  • mshmyob
    Recognized Expert Contributor
    • Jan 2008
    • 903

    #2
    Put it in the ON CURRENT event instead.
    Originally posted by 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..

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

    Comment

    • zivon
      New Member
      • Aug 2007
      • 59

      #3
      thanks mshmyob :) thats exactly what I needed.

      Comment

      • mshmyob
        Recognized Expert Contributor
        • Jan 2008
        • 903

        #4
        You are welcome........ .............

        Originally posted by zivon
        thanks mshmyob :) thats exactly what I needed.

        Comment

        Working...