I have a Table which contains:
a field [EntryDate] (Date Format) and
a field [EntryHour] (General Number-ie 1, for hour one)

It also has a number field called [Field1] and
a number field called [Field2].

I woul like to carry the number from [Fieldone] into the next [Hour]s
[Field2]

I am able to do this during data entry by using dlookup, but if the
number in [field1] is changed, the next [Hour] does not know to look
back.

So, I would like to cause all records on a form to be updated during
the form closing process.

For each record, with the same date, I need to copy the previous hours
[Field1] forward to [Field2].

Thanks