Automatically fill record with data from previous record

M

MOSE1

I have no experience writing VB scripts. I need a single field in a form to
automatically fill with the previous data that was input into it. Could
somebody please help. I have seen similar scripts from multiple fields and
I can't seem to edit them to work for my situation. Thanks
 
J

Jeff Boyce

There's a keyboard shortcut that will "copy" the previous record's field to
the new record when your cursor is in that field (<Ctrl>-<'>).

If you want a specific field in each new record to start out with a default
value equal to the previous record's value in that field, you'll need to
change the default for that field.

One way to do this is to add code to the form's AfterUpdate event, something
like:

Me![YourField].DefaultValue = Me![YourField]

Good luck

Jeff Boyce
<Access MVP>
 
Top