Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2002
    Location
    Thailand
    Posts
    81

    Unanswered: Last Updated field

    Hi, wanna make a last updated field, where the date is reset everytime something is changed in a record.

    Can´t seem to get hold of the correct form event.

    I figured I could just do

    me.lastupdated = now()

    in some event that means "if anything in this record is changed". What event is that? It would suck having to set me.lastupdated = now() as on onChange Event in every possible field on the form.

    Kind Regards

    Jo´
    Last edited by Johnny Dove; 10-14-02 at 08:03.

  2. #2
    Join Date
    Jul 2002
    Location
    Romania
    Posts
    122
    Form_BeforeUpdate(Cancel As Integer)
    Me("LastUpdated") = Now
    End Sub

    That will do the trick.

  3. #3
    Join Date
    Jul 2002
    Location
    Romania
    Posts
    122

    Re: Last Updated field

    sorry, forgot the Sub...

    Private Sub Form_BeforeUpdate(Cancel As Integer)
    Me("LastUpdated") = Now
    End Sub

Posting Permissions

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