469,348 Members | 1,263 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,348 developers. It's quick & easy.

Field Checklist Input Form w/checkboxes

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! :)

Mar 28 '06 #1
2 4206
It appears that your table structure is not normalized. I would break
apart the one table (Inspections?) into two: Inspections and
InspectionDetails. This would work much like Orders and OrderDetails
in the Northwind Sample database. A subform would be used to enter
data. Then, you can use a query to join the tables and show the
results that you want in a report.
Chris

Mar 28 '06 #2

ch************@gmail.com wrote:
It appears that your table structure is not normalized. I would break
apart the one table (Inspections?) into two: Inspections and
InspectionDetails. This would work much like Orders and OrderDetails
in the Northwind Sample database. A subform would be used to enter
data. Then, you can use a query to join the tables and show the
results that you want in a report.
Chris


Hi Chris,

I have two tables for the inspections an inspections details and
inspections table. These two tables populate the combo boxes.

Thanks so much for your recommendations.

Mar 28 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Emanuel Marciniak | last post: by
1 post views Thread by Jim | last post: by
1 post views Thread by J Talbot | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.