Creating Form for data entry

[Guest]

I'm trying to find an easy way to allow entry of data from a form. I've
created tables that I use to print the forms. There are at least 8 similar
forms with as many as 100+ different line items on each form. For each line
item I need to allow someone to enter a value assigned to the training level
of an employee for that task (or line item). I know what the line items are
based on linking the tables via the form code. I'd like to display the line
items and only require the entry of the training level for each line item.
What is the best way to do this? Each line item is to be stored in a table
so I can do analysis of the results.

 

[Guest]

You might want to reword your question. As it is, it's a little difficult to
understand what you are trying to accomplish. For example;

You stated "I've created tables that I use to print the forms"

Tables are used to store data, they don't "print forms". Additionally, in
Access you don't print forms, you print reports. Forms are used for data
entry.

Maybe you mean that you *created* the forms based on the tables, but we
don't really know.

You also said "There are at least 8 similar forms with as many as 100+
different line items on each form."

Does this mean that you have 8 different forms based on 8 different tables,
but they are all basically the same? If so you have a design problem with
your DB.

Lastly, you said "I know that the line items are based on linking the tables
via the form code"

Tables don't link "via form code". Tables are *linked* via relationships
based on fields within each table.

 

[Guest]

You are correct and thanks for the terminology lesson.

I have created tables that store the information concerning the various
forms that are used. I have a forms table (stores the basic information for
the various forms), a group table (stores the groups used for each form), and
a task table (stores the tasks used for each group). Using the relationships
between these 3 tables, I can create the reports for each form and print
them. Now I want to create the data entry forms to enter the results for
each task. I know I can use drop down lists to have each task item selected
and the result then entered for that task item. But is there a way to create
an entry form that will display the tasks for each group on the form and only
require someone to enter the result?