Use a form to add multiple records to a table at once?

[joncue]

We have employees do a daily audit on all our process activities for the day, but currently these are just filed as records and not utilized to drive internal improvement. I created a database that we can keep track of the question category, the specific requirement, and then whether the process passed or failed that particular part of the audit. I would like the data entry person to be able to go into a form with all the questions already in it, and then just check the pass/fail box to indicate whether the audit was passed or not, so that I can then chart where we fail the most and direct our improvement activities to those areas. The audit table has a column for the question ID and whether or not the audit was passed, how do I create a form pre-loaded with all the questions, and then insert the question ID's and audit results into the table at once?

Thanks in advance for any help.

 

[jeds]

joncue, if you create a new form and go to layout view, then click "Add Existing Fields", you can drag or double-click the fields you want in your form.

Depending on what you have for tables, you may need to have relationships between the tables.

This is offerred by an Access newbie, but might get you started until a pro comes along.

jeds

 

[joncue]

Thanks Jeds. The problem in my case is that I need the data entry screen to have all the questions on a single form so that the data entry person can fill in the blanks. Each question will then have to be entered as a separate record in the audit table. Since the questions will always remain the same, I am trying to figure out how to have a single form with all the questions already listed, then added to the table, rather than having someone go through 25 separate entries individually, so I can't just add the fields to the data entry form. It's a little hard to explain (and I just got in, not awake yet), been beating myself up for awhile trying to figure this out with no luck.