Multiple checkboxes totaling to give me a value??

[Guest]

I have an evaluation form I have created. To help make this process more
efficient I changed it from text boxes to checkboxes.

If the same type of check box is checked 4 times I would like for the form
to total that & have the number 4 appear in the table.

Is this possible??

Any help will be appreciated & thanks in advance.
TT

 

[Michel Walsh]

Hi,


How do the user "delete" an erroneous "click" ?


A possible way is to have a form variable ( a variable declared in the form
declaration section), or an array, with one element for each "control" to
monitor.

Set that variable to 0 (it is done automatically when the form is loaded).

Increment that variable by one on its click event.

When the table is about to be closed, in its Unload event, append the value
to your table with an

CurrentDb.Execute" INSERT INTO tableName(listOfFields)
VALUES(listOfValues) "

as example.



Hoping it may help,
Vanderghast, Access MVP