Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    28

    Exclamation Unanswered: Date Stamp on Populated Table

    I have a table that contains six fields. One of these fields is a DateStamp field. Another of the fields is an identification number. I want the DateStamp to be updated to Now() when the ID Number is changed on the data entry form. I can get the datestamp to set when I create a whole new record, but I have several thousand ID's that will be changed and updated over the next four months. I want to be able to track how many are being changed each week by using the datestamp. How can I set the DateStamp field to update to Now() when I change the ID Number field of a current record?

    Thanks,

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Set the value in the after update event of that control on the form.
    Paul

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    To expand pbaldy's response:

    Code:
    Private Sub IDNumber_AfterUpdate()
       Me.DateStamp.Value = Now()
    End Sub
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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