writing table using checkboxes

[dedjloco]

I made the following form and the strat of a table. The idea is that when a checkbox is checked that either the corresponding checkbox in the table is checked or I could copy the corresponding record to a new table. But in the end I want to cound all the scores and calculate the average of all the checkboxes that are checked.
But I'm stuck because I can't find the easiest way to do this.
Any idea's?

 

[Ranman256]

(i cant download) but,
the easiest way is not to use checkboxes on a single/continuous form. When you change the table you must constantly update the form.
Now if you use a datasheet view form, you dont have to reformat the form everytime.
you most likely made a dozen fields on a record, which cant be summed because access sums vertically, not across the record.

The easy way would be to have a subtable so there's 1 question per record.
1. favorite color
2. best dog
3. etc

this base table of questions is added to the subtable of the Client so every client has all the questions. 1 Q per record.
CLIENT, Q, A
99, 1,0
99, 2,-1
99, 4,0

then you sum them in a normal query.
But if you have the 50 Q on 1 record, then to sum them you must use VB to scan the fields.
Good news tho, if you are summing questions of all persons surveyed about Q4, then a normal sum query can work here.

 

[dedjloco]

Thank you for the reply. I think that your method doesn't work for what I want, because there are more answers possible on one question. If you translate it to your idea.
Do you know why you can't download?
And maybe I'm wrong, because I don't understand what you mean with the datasheet view form. And I think we can understand eachother better when you see my form.