Form Set Up for Data Entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I set up a form for data entry so users don't have to type the same
comments multiple times? I want users to enter only one comment that
potentially could apply to multiple Project IDs. Users would enter Client ID
(one record), project ID (could be more than one ID per client ID), Agreement
ID (could be more than one per client ID), and Comment. I would like to
minimize data entry so they could enter only once client ID and one comment.
The same comment will apply to multiplie project IDs and multiplie Agreement
IDs. Is it possible to desing such a structure in Access? I'm assuming that
client ID - Project ID - Agreement ID would be a unique record.
 
monia13 said:
How do I set up a form for data entry so users don't have to type the same
comments multiple times? I want users to enter only one comment that
potentially could apply to multiple Project IDs. Users would enter Client ID
(one record), project ID (could be more than one ID per client ID), Agreement
ID (could be more than one per client ID), and Comment. I would like to
minimize data entry so they could enter only once client ID and one comment.
The same comment will apply to multiplie project IDs and multiplie Agreement
IDs. Is it possible to desing such a structure in Access? I'm assuming that
client ID - Project ID - Agreement ID would be a unique record.
Click to expand...
 
It sounds like you're already using an acceptable form to enter data. After
entering a comment in one record, to insert the same value in the next
record, use the shortcut CTRL + ' [apostrophe key].
 
Back
Top