MS Access Form - Copy value from previous row

In MS Acces 2003 I had a macro when using a form on a new row I could copy and paste the value of the same field in the previous row.  I used a SEND KEY ^'.  How can I do the same thing in Access 2013?
Who is Participating?
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPConnect With a Mentor Commented:
Is this a foreign key to relate the record to another record. If thatis the  case and it is a master/child relationship,  Access will handle it for you automatically if you use a sub form.

Another option is to use the control's after update event to set the default property to the value in the control.

Also see:

Assign default values from the last record

Sometimes you need to design a form where many fields will have similar values to the last record entered, so you can expedite data entry if all controls carry data over. There are two ways to achieve this:

    Set the Default Value of each control so they offer the same value as soon as you move into the new record.

    Use the BeforeInsert event of the form so they all inherit the same values as soon as the user starts typing in the new record.

Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
copy and paste the value of the same field in the previous row.
Then I will presume this is a continuous or datasheet form...
If so, you can use the Access shortcut key combination Directly


(Hold down the Ctrl key, ...and tap the:  '  key)

This does the same thing you are doing with sendkeys...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.