Copy Field from Prior Record

C

Connell Giacomini

Our data-entry form is programmed to duplicate data from six corresponding
fields in the prior record.

The code we use (On Enter event) is:

Private Sub (Data Entry Field)_Enter()
SendKeys ("^'")
End Sub

This works for only four of the six fields, forcing the operator to use
Ctrl+' to copy the data into two of them.

The form was created in Access 2007, on a Windows Vista PC, and works
perfectly for all fields.

The form was imported into Access 2007 on a Windows XP machine and only work
for 4 of 6 fields.

Is there a better way (instead of SendKeys) for doing this?

Connell Giacomini
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form - Lock Fields from Editing 0
Adding new record to a form 1
Access 2007 form fields stuck on "New line in field" 8
Filling in fields to a partially complete record in a table using a form 0
Populate field from previous record 0
Access Automatically Send a notification email once a record is added 0
Access How to record date/time when specific field is modified in Access 2007 0
Repeating selected fields into the next record 2

Top