• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Working with Forms > Copying Data from One Record to Another

Copying Data from One Record to Another

The worst part of data-entry drudgery is inputting data that comes in groups—a long list of orders from a single customer, a bunch of folks from the same town, a crate of books from a publisher, and so forth. Forms make it easier to enter this sort of repetitive data into your tables. You can avoid entering the same data over and over again by copying the data from the previous record to a new one.

To copy data from one record to another:

1.
Click the field where you want the value from the previous record to appear.

2.
Press Ctrl-'(Ctrl + apostrophe).

Data from the previous record appears in your field ( Figure 4.9 ). Wasn't that easy?

Figure 4.9. Pressing Ctrl-'copies data from the same field in the previous record.


Tip

Other keyboard input shortcuts include Ctrl-Alt-Spacebar (to enter the default value for a field); Ctrl-; (to enter the system date); and Ctrl-: (to enter the system time).


Tip

Keyboard shortcuts for moving around in a form include Ctrl-PageDown (move to the same field of the next record); Ctrl-PageUp (move to the same field of the previous record); Ctrl-Home (move to the first field of the first record); End (last field of the current record); and Ctrl-End (last field of the last record).


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint