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
thank you SO much in advance! :)
