Copying Data from the previous record

[MarionD]

Hi all,
Again I need a little help from my friends!

Can someone tell me how I can copy just one field from the previous record into the next record? On the keyboard (German) this can be done by ctrl-hash. I want to put a procedure on double click that will copy the field from the previous record.
Thanks a mill

 

[jdraw]

Since you are writing a procedure, you might consider creating a variable. Then using a recordset (or another construct if you have something else in mind) and saving the field value in record 1 to the variable; then in record 2 (next record) update the field with the value in the variable....

If that doesn't apply, see Allen Browne's stuff on subquery

http://allenbrowne.com/subquery-01.html
get the value from another record

 

[pbaldy]

Or perhaps this?

http://allenbrowne.com/ser-24.html

 

[MarionD]

Thanks a million guys!