Display a field from a previous record... 
Author Message
 Display a field from a previous record...

I am trying to show, in record 2, the details from the same field in record
1, can anyone shed some light... I have tried to use the command...

DoCmd.GoToRecord, [Record number],acLast
To bring through the previous record details to a field on the current

Number = 150 in record 1
Running total = 0 in record 1

Number = 80 in record 2
Running total = 150 in record 2

Number = 425 in record 3
Running total = 230 in record 3

Many thanks in advance

Sat, 13 Mar 2004 00:10:30 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Auto-filling fields in a new record with info from a previous record

2. Word 97: Displaying Previous month with fields???

3. Field to display previous month

4. Word 97: Displaying Previous month with fields???

5. Replicating fields using previous record's data

6. default field to value of previous record

7. Reference previous record field value

8. Module - autofill fields from previous record.

9. Field from previous record

10. Filling a record with data from previous record

11. Replacing The Text String Value In A Record With That From A Previous Record

12. Update a record using a previous records value


Powered by phpBB® Forum Software