Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    1

    How to display data from another record


    hello, im new in access. An accountant has asked me to do a form in access to manage her information. She wants a form where she could view balance info from the previous record. Does anyone know how to display on a form data from another record? thanks for your help

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    In the "On Current" event of the form, save the field from the current record, something like this:

    Private Sub Form_Current()

    Static prevVal

    Me.PreviousVAlue = prevVal

    prevVal = Me.NewValue

    End Sub

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

Similar Threads

  1. Replies: 3
    Last Post: 10-23-2008, 08:43 AM
  2. drop down wont display
    By gromit95 in forum Database Design
    Replies: 3
    Last Post: 10-21-2008, 11:12 AM
  3. Find data, load data, and save as a new record
    By hawzmolly in forum Access
    Replies: 0
    Last Post: 10-05-2008, 03:18 PM
  4. Deleting Record Contents, not complete record...
    By Charles Waters in forum Access
    Replies: 2
    Last Post: 06-24-2008, 12:00 PM
  5. Replies: 1
    Last Post: 03-02-2006, 06:17 AM

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