Copy previous record.

[Guest]

What is the easiest way to copy a previous record (all but one field)? I produce small lots of items that need to keyed into my database. Not much is different from record to record until the items ship. There are two subforms within the main form. Thanks

Mike

 

[dandgard]

I keep a set of variables that are global to the forms class and can b
associated with the individual fields values that I want to keep trac
of. I then set the variables in the forms afterupdate. Then I set eac
fields default property to a class function that returns the value o
the variable I want for that field.

This way the new record is not "dirty" and won't be saved unless yo
make an entry to a field in the underlying table for the form

 

[Keitaro]

I keep a set of variables that are global to the forms class and can be
associated with the individual fields values that I want to keep track
of. I then set the variables in the forms afterupdate. Then I set each
fields default property to a class function that returns the value of
the variable I want for that field.

This way the new record is not "dirty" and won't be saved unless you
make an entry to a field in the underlying table for the form.