Appending Data

[mugman17]

I know you can duplicate all of a records data to a new record, but I only want to paste certain fields from the current record into a new one. How do I go about this. For instance I have a field called TransactionDate. Is there a way just to append this to the new record?

Thanks.

 

[Fornatian]

try here:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=19801&highlight=defaultvalue

otherwise do a search on defaultvalue and that will definitely answer your question.

 

[mugman17]

This works well if you want a default value for every record. All I need is something that takes 5 fields from the current record and transfers to the new record when a command button is pressed.

 

[Fornatian]

If you read alexandre reply in the post above you will see she specifies how to indicate which fields should be carried over to the next record.

The easiest way I know to do this is to type an apostrophe ' in the form field which will enter the previous record value.