Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Smile Populate date from previous record


    In a form in Access, I would like the last records date to be populated in the new record and I would also like to change the date if required.

    I would be grateful of some feedback.

    Thanks
    Liane

  2. #2
    thhui is offline Competent Performer
    Windows XP Access 2002 (version 10.0)
    Join Date
    Feb 2009
    Posts
    235
    On the NewRecord event,
    Use the vba code to search the last record you have entered and
    then put this into the field you want.

  3. #3
    Fernanvel is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    2
    Thank you for your replay but I still not able to figure it out. If possible, can you be more step by step?

    Thanks

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922

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

Similar Threads

  1. using value from previous record
    By dollars in forum Queries
    Replies: 0
    Last Post: 12-10-2008, 03:30 PM
  2. auto populate and table relationships
    By jmarti57 in forum Access
    Replies: 0
    Last Post: 11-09-2008, 09:50 PM
  3. Auto populate fields on a form
    By ldarley in forum Forms
    Replies: 0
    Last Post: 08-14-2008, 09:39 AM
  4. Date Stamp On Entry of Record
    By tscholts in forum Forms
    Replies: 3
    Last Post: 04-01-2008, 07:08 PM
  5. Replies: 1
    Last Post: 09-20-2007, 02:56 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