Control apostrophe

[Leo]

When you press Control Apostrophe the previous record's data is entered into
the field on a form. Is there a code that I can enter On Load property of
the form so that some (not all) of the fields will automatically fill in with
data from the previous record.
In other words is there a VBA code for Control Apostrophe?

Thanking you in advance
Leo

 

[Allen Browne]

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

The code carries data over at the point when you start entering a new
record, and you can specify the fields *not* to assign values to (just by
adding the names of those controls in quotes.)