Form Experts please help

[Incolor]

Hello All!

I have to generate a checklist form as an input form in Access. A paper

form is taken out in the field and checked yes, no, OR n/a for each
item inspected. The problem I am having is this, the form should have a

main heading with the date, report no, and inspector. This information
should be entered only once in the form, but recorded for each item
inspected in the database table. Under the main heading there is
another heading with the group name of the inspected items, a YES, NO,
N/A, followup, date, comments. Below these headings are the detailed
inspected items and for each item the YES, NO, N/A, or followup, date,
and comments should be entered. The YES, NO, N/A, and followup are all

check boxes.
After all the information or items have been checked another group
heading starts with the same headings. I have a total of 12 groups all

with 1-20 detailed items that are checked for each.


The way I set up the form is with two synchronized combo boxes for the
group and the group details. The user chooses a group first and then in

the second combo box is populated with the group details pertaining to
that group. When I enter the data however only the first group and
group detail information that I enter is saved in the table. How do I
get it so that it records all the combinations the user may choose?


I was able to create a report in Access with no problem, since you have

grouping and sorting with reports. Anyone, have any ideas on how I
could generate this form so that each record is saved in the table with

the same date, report no, and inspector and the group and group details

and checkboxes, date and comments? This is what the form looks like:


Form Heading: Title of Checklist Form
Detail: Date, Report No., Inspector
Combo boxes: group
group details
check boxes: yes no n/a followup date


comments

Can forms have grouping like reports?

thank you SO much in advance!

 

[Klatuu]

I reread you post a number of times and still think I don't fully understand.
What I think you are saying is you want to enter data that represents the
results of testing.
There are 3 levels you want to include.
The highest level is date, report number, and inspector.
This data only identifies the report.
A report has Groups
A group has a name. Is there any other data that is specific to the group?
A Group has Items
For each Item you want to collect:
yes no n/a, followup date, comments

Does an item always belong to the same group?

As to Grouping like reports, no, but sort of. This may be a candidate for a
Form/Subform configuration. That is why I am asking the questions above.
There are a number of ways to do this depending on the data structure. I see
at least three tables.

tblReportHeader
RptHdrID (AutoNumber Primary Key)
ReportNumber
Inpector
InspectDate

tblReportGroup
RptGrpID (AutoNumber Primary Key)
RptHdrID(Foreign Key - Related to tblReportHeader)
GrpName

tblReportItem
RptItmID (AutoNumber Primary Key)
RptGrpID(Foreign Key - Related to tblReportGroup)
RptResult
FollowUp
FollowUpDate
RptComments

First, your Yes, No, N/A should be in an option group that will return
values of say 1 for Yes, 2 for No, and 3 for N/A. Using an optiongroup, you
can select only one. I assume there would be only one answer.

So here is how we group. We need a 3 layer Form/Subform configuration. The
main form will be bound to the Report Table. It will have a Subform that is
bound to the Group table which, in turn will have a SubForm bound to the
Items Table.

Once you have this configuration set up, navigating and updating become non
issues.

 

[Incolor]

Thank you SO much! I will try this...