Results 1 to 4 of 4

Thread: auto update

  1. #1
    Join Date
    Jan 2015
    Posts
    23

    Unanswered: auto update

    Gud day,
    I havr been trying to disable or lock record after update. This is the code I used

    Private Sub jan_AfterUpdate()
    If Me. jan < 100 Then
    Me.jan.Enabled = True
    Else
    Me.jan.Enabled = False
    End If
    End Sub

    It works but each time I refresh orclose the database, that disabled field becomes enabled agin.
    Pls I need ur help. Thanks for ur usual support.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You would need the same code in the current event of the form (or call a function from both events).
    Paul

  3. #3
    Join Date
    Jan 2015
    Posts
    23
    Thanks Paul, that solved the problem. I appreciate.

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Happy to help!
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •