Using Data from a Previous Record

[Paul Maher]

I originally posted this on the "general" board. I have deleted it from there and reposted.

I'm writing a database to catalogue my Video Tapes.

The two relevant tables and fields are:

(Table 1) TBL_VIDEOTAPE (Table 2)TBL_PROGDETAILS

TapeID (Join) TapeID on both Tables

(Field) in ProgDetails "ProgStarts" (Time format 00:00:00)
(Field) in ProgDetails "Prog Ends" (Time format 00:00:00)

I use two forms (FrmTape & FrmProg) and join on TapeID.
The FrmTape has a command button which opens the FrmProg
and adds a new record.

The natural data entry progression is:
1 Enter first prog on the tape (ProgStarts) as 00:00:00
2 Enter end of prog (ProgEnds) eg 01:30:00
3 Record 2. Enter ProgStarts 01:30:00
4 Enter ProgEnds eg 02:25:30
Repeat process for subsequent programmes (steps 3-4)
Each new record's ProgStart is the previous record's
ProgEnds (apart from record 1).

At the moment i'm using copy/paste to achieve this.

QUESTION: Is there a way (using Access VB) to "lookup" the
previous record's ProgEnd and populate the current
record's ProgStarts?

I'm using Access 2002 and although i'm getting used to
using code, it would be helpful if you could tell me where
to attach the code and what sort of Event it should be.

Thanks a lot for your help

 

[Rich]

You can use the PrevRecVal function, or other methods have been posted here for something very similar, try searching for Previous and CarryForward

 

[Paul Maher]

You can use the PrevRecVal function, or other methods have been posted here for something very similar, try searching for Previous and CarryForward

Rich,

Thanks for this. I'll do some searching and also some reading through my Access Books.

Appreciate you reply.

Paul