Coping fields

[jamccarley]

I have created a database that tracks all of the suspect parts we place on
hold. There are many occasions that there is need to write more than one tag
with all of the same information, except for 2 fields (there are 17 different
fields). I know that (Ctrl ") will copy individual fields from the previous
record, but is there a code that i could put in the database to duplicate all
of the fields except for the 2 that change on the click of a button. One of
the fields is [Part_No]. Form name is [Hold_Tag]

Thanks
Josh McCarley

 

[Allen Browne]

See:
Assign default values from the last record
at:
http://allenbrowne.com/ser-24.html

The article contains code to copy and paste into a standard module. You can
then use it in any form by adding just a tiny bit of code (step 9.)

And you can specify fields that should not be copied over.