How to copy a value from a previous record into the current record

[Rex]

Hello,

I would like to know how to copy a value (from a textbox or other
controls) from the previous record into my current record.

cheers
Rex

 

[Guest]

Hi Rex,

Here are a couple of methods:

How to fill record with data from previous record automatically (in
Access 2000)
http://support.microsoft.com/?id=210236

Note: Should work fine in A2002 and 2003 as well.

Duplicate the record in form and subform
http://allenbrowne.com/ser-57.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Joseph Meehan]

Hello,

I would like to know how to copy a value (from a textbox or other
controls) from the previous record into my current record.

cheers
Rex

Shortcut key Cont + ' That is the control key and the apostrophe.
It will copy the data in the same FIELD of the prior record.