I am trying to carry the text I enter in several fields from one record to the next record without having to retype it in the new record. How can I do this? Thanks in advance for your response.

There are two ways to do this. Look at the Microsoft knowledge base article Q136127.

hi i have the same problem but rather it being the last or previous record it is a searched for record whos details i want duplicated into another table any ideas??