Include a field from previous record on current form

[Guest]

Can anyone explain how I can include a field from the previous record in an
unbound text box on a form or report of the current record?

I have a form which includes fields for storing the current quantities of
liquids in tanks. What I would like to do is show what the volumes were
previously on the form as well. I want to be able to view this for any record
not just when adding a new record.

Thanks

 

[missinglinq via AccessMonster.com]

One way would be to assign the value to a global variable. The global
variable should be declared in a standard module, not in the coe module
behind a form. This would keep the level(s) available for the current Access
session. Of course, if you want it to carry over after you close the database
and then open it again, you'll have to write the value to a table.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Guest]

Thanks for the reply.
Unfortuately it was not the solution I was looking for. May be I did not
explain things very well.

I would like to include the current tank level from record 1 as the previous
tank level on the form for record 2; the current tank level from record 2 as
the previous tank level on record 3 etc.

Do you or anyone else have any ideas.

Thanks

Fred