Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Oct 2001
    Location
    New York
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Record update field (Access 97 SR2)

    I would like a field in my form, which when changes are made to the form, the date updates to the current date. If the user is just looking at the record, no changes are made to this update. Do I start by inserting a Text box and then having it show the current date?

    Thanks
    Nadia

  2. #2
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Wellington, New Zealand
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Record update field (Access 97 SR2)

    You will need a field in the underlying table.

    Then you will want to add a textbox on the form bound to that field. You would probably want the textbox enabled = false, to stop users from manually entering dates.

    Then use the BeforeUpdate property of the form / record to set that text box to the current date.

    Cheers

    Jayden

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Record update field (Access 97 SR2)

    See this Previous Post


    HTH

    Peter

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Record update field (Access 97 SR2)

    Not Enabled = False, Locked = True.
    Charlotte

Posting Permissions

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