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?
leewallinAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
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: http://allenbrowne.com/ser-24.html

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.

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS 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

    Ctrl+'

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

This does the same thing you are doing with sendkeys...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.