Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    10

    Question Unanswered: Using value from previous record in current record

    is there anyway that i can take a value from a previous record on a form and use it in a calculation in the next new record on the form, ie the form is used to display and work out continuous calculations, and the total of the previous record is used in calculating the total of the next new record.

    hope this makes sense

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    You could consider a hidden text box on your form.

    You could add a default dlookup on a query that sums all previous data to the text box, and then use the text box to add to the new record to obtain a new total.

    HTH

Posting Permissions

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