Check-List Question

[dee]

In the survey db that I am creating, I have many surveys that are filled in
by many people.

At the end, the group of surveyors that administer the surveys fill in
check-lists about each individual that includes their id number and a
checklist that indicates which surveys they completed with Yes, No, NA that
they circle beside each survey name. There is also a section for comments
that may be filled in.

Should I have a separate table for the checklists? To me, it's just another
survey that's filled in - questions and answers - but maybe I'm missing
something.

Any and all advice is greatly appreciated!

 

[Duane Hookom]

Survey names (like questions) should not be field names. A properly
normalized survery would have each survey for each individual create a new
record.

 

[dee]

Yes, I see that in your AYS database. I also need to add reasons why they
didn't respond, if they didn't, surveyor ID who completes the checklist,
respondent ID, date and time the checklist was completed. I guess this extra
information is causing me to question how to approach this.

Also, one of the checklists refers not just to the surveys completed, but
also to specific questions in clinic test, such as blood pressure, etc.
because it is possible that an individual may have started part of the
testing, then for some reason not completed it.

 

[Duane Hookom]

I wasn't trying to suggest this information needs to be stored in the table
of responses. You could add fields to tblSrvRspns which contains one record
per survey per person.

 

[dee]

So, add fields that not only indicate who answered which survey (as you
already have), but also the other checklist data, such as comments, if
completed entirely, etc?

On an un-related note, I am pulling my hair out trying to understand this
code:
rivate Sub section_AfterUpdate()
section = Right$(" " & section, 4)
End Sub

I know it's to update the form to show up-to-date data, but I keep getting
an error "Compile Error - Argument not Optional" when I try to add to the
Qlvl1, which I have renamed Section to better represent the surveys.

Thanks

 

[Duane Hookom]

This code
section = Right$(" " & section, 4)
is to allow for proper sorting of a number or whatever stored in the text
type field.

You changed my field name to a reserved word. That is what is causing your
error. Every form and report has "sections" so naming a field "section" will
create issues.

 

[dee]

Thank you Duane, for clearing that up. I will go back and restart this.

Thanks for your kind patience as well. I really appreciate it.