Re: Copying data between fields

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If you are copying in a Data*** View or in a multi-record form, CTRL-' (Control apostrophe) will copy the data from the record above it. If you are in a date field, CTRL-; (control semicolon) will insert today's date. Just a small bit of trivia it took me 10 years of using Access to learn!!! <g>

Dudley wrote:

I have created a database in Access XP to record details about companies, and I would like to have command buttons on the data entry form to copy data where the same person occupies more than one position (to avoid having to repeatedly enter the same data). For example after entering company secretary details, clicking 'Also Director' would copy secretary forename field to director forename field, surname to director surname etc.

Can anyone tell me the VBA code for copying data between fields in a form please? 
.

Quantcast