Results 1 to 2 of 2
  1. 10-06-2011, 02:41 AM #1
    leonhuynh2006
    leonhuynh2006 is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2011
    Posts
    9

    Previous record

    Dear all,

    Please help me with this problem. Let say I have the following situation:

    DateOfOrder
    1/1/2012
    15/1/2012
    30/1/2012
    10/2/2012

    When the date of the form is on 15/1/2012, I would like a text box, called "previous date", display the 1/1/2012. When it move to 30/1/2012, then the textbox will display 15/1/2012. How would I do that.



    Best regards.
    Reply With Quote Reply With Quote
  2. 10-06-2011, 06:41 AM #2
    alansidman's Avatar
    alansidman
    alansidman is offline Indifferent
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536
    Look at this in MS KN

    http://support.microsoft.com/kb/101081/en-us

    Alan
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Auto increment a number based on record value from previous record
    By markw in forum Access
    Replies: 8
    Last Post: 07-06-2013, 05:13 PM
  2. how to copy previous record data to next record ?
    By alex_raju in forum Access
    Replies: 1
    Last Post: 07-25-2011, 09:41 AM
  3. How to populate previous record with next record value
    By asrivas1 in forum Programming
    Replies: 1
    Last Post: 04-21-2011, 11:27 AM
  4. Seeing Image from Previous record ......
    By cowboy in forum Reports
    Replies: 1
    Last Post: 02-24-2010, 08:38 AM
  5. using value from previous record
    By dollars in forum Queries
    Replies: 0
    Last Post: 12-10-2008, 03:30 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums