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
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