update table by check boxes

[sancho]

I need to update table by using multioptional check boxes.

I need to allow user to select more than one option from check box group. The
check box values will be saved into table with customerID and check box value.
Optional check box group allow to select just one option.

If the user uncheck the check box, the value will be deleted from the table.

How to make it?
thanx

 

[Michel Walsh]

Hi,


Rather than immediate individual deletions, save the check box too (checked
= true, unchecked = false) under a field of the table and, when maintenance
is required, issue a massive, single, delete:

DELETE * FROM tableName WHERE checkBoxField = false

I also allow the end user to... oops... , to undo, to re-check a checkbox
he/she unchecked, by error, as long as the maintenance steps has not run.

Hoping it may help,
Vanderghast, Access MVP

 

[sancho via AccessMonster.com]

Still need how to check more checkbox in optional check box group and save it
to a table.

Hi,

Rather than immediate individual deletions, save the check box too (checked
= true, unchecked = false) under a field of the table and, when maintenance
is required, issue a massive, single, delete:

DELETE * FROM tableName WHERE checkBoxField = false

I also allow the end user to... oops... , to undo, to re-check a checkbox
he/she unchecked, by error, as long as the maintenance steps has not run.

Hoping it may help,
Vanderghast, Access MVP

I need to update table by using multioptional check boxes.

[quoted text clipped - 9 lines]

How to make it?
thanx

 

[Michel Walsh]

Hi,



Generally each check box will correspond to a column, each check box in the
form bound to a Yes/No column in the table.

I am not sure I understand the whole scenario.


Hoping it may help,
Vanderghast, Access MVP.