reoccuring data entries

[Guest]

I have a large amount of entries that I have entered into the table and was
wondering if there was an easier way instead of copy and pasting the contact
information into another field and then altering it. As in, with a
description of a job, the company location, address, date built and that kind
of information would be the same, however different employees might be
working for the company and would need to be selected from another drop down
list.

Basically comes down to, not needing to copy/past and having drop down boxes
to explain fields that need more information for them

 

[John Vinson]

I have a large amount of entries that I have entered into the table and was
wondering if there was an easier way instead of copy and pasting the contact
information into another field and then altering it. As in, with a
description of a job, the company location, address, date built and that kind
of information would be the same, however different employees might be
working for the company and would need to be selected from another drop down
list.

Basically comes down to, not needing to copy/past and having drop down boxes
to explain fields that need more information for them

With properly normalized tables, it should rarely be necessary to have
repeating fields. If you do, and they're legitimate, there are a
couple of data entry tricks to speed the process up. One would be to
use Ctrl-' as a keystroke to "ditto" the value of the current control
from the previous record; another is to use a bit of VBA code in the
Form Control's AfterUpdate event:

Private Sub txtJobDesc_AfterUpdate()
Me.txtJobDesc.DefaultValue = Chr(34) & Me.txtJobDesc & Chr(34)
End Sub

If you're entering data directly into a table... well, *don't* enter
data directly into tables. They have no usable events and aren't
designed for that purpose - use Forms.

John W. Vinson[MVP]