Results 1 to 4 of 4
  1. #1
    LionsCricket is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Apr 2013
    Posts
    2

    Auto Update Question

    Hello,
    I am trying to create a feature in my database that will auto populate the date in my "last updated" field whenever someone clicks the "save record" button on a form. The intention is to be able to see the last day that changes were made to an exisiting record. I can't figure out how to do this, I built this database using the web and a book, so I am pretty novice.

    Many thanks in advace to any help you can give me.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    In the code behind the button:

    Me.TextboxName = Now()

    where TextboxName is the name of the textbox bound to that field.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    LionsCricket is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Apr 2013
    Posts
    2
    Quote Originally Posted by pbaldy View Post
    In the code behind the button:

    Me.TextboxName = Now()

    where TextboxName is the name of the textbox bound to that field.


    Thank you pbbaldy, I would like to use the "save record" button as the item the field is bound to. Is that possible?

    Many, many thanks.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    I don't think so. I'd just have a textbox on the form bound to that field. It can be hidden from the user.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Yet another auto fill question
    By Yensid in forum Forms
    Replies: 9
    Last Post: 11-16-2012, 03:26 PM
  2. Auto Format question
    By Trojnfn in forum Access
    Replies: 7
    Last Post: 10-02-2011, 05:12 PM
  3. Auto-populate form question: again!
    By revnice in forum Access
    Replies: 5
    Last Post: 08-06-2010, 04:02 PM
  4. new guy with a question on auto populating
    By zdiver07 in forum Forms
    Replies: 2
    Last Post: 05-03-2010, 11:06 PM
  5. Auto Exec question
    By wilhelmmt in forum Access
    Replies: 4
    Last Post: 04-22-2010, 05:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums