Updating a database with a number of check boxes

[shaz123]

Hi,
I have got part of this working, im trying to edit a table through a form after the user has selected a check box. What I cannot get working is when the user clicks on more then one checkbox. It must be some kind of loop that i need to inlcude can you anyone help


I have attached the code within a word doucment

 

[grnzbra]

You could try a For Next loop and loop through all the objects on the form. If the object is a checkbox use it and continue the loop.

 

[shaz123]

Check Box

Hi thanxs for your help,

if you luk at the coding, once the check box is ticked the information is only added in acordance to that cylinder number, in desing view of the form there is only one cylinder number textbox. Therefore how would i make it possible for the information to be added for that particular cylinder number if there is more then one check box selected. Some one suggested creating an array. Any ideas!

 

[grnzbra]

So, is the cylinder number related to which check box is checked? Is that correct?

Assuming that the check box tells you which cylindar to add the info to and you are going to add one record for each cylindar, you could add another loop that loops through the checkboxes and when it finds one that is checked, get its name and then use your code to process it. Then loop and repeat the process.

 

[shaz123]

Checkbox

Hi,

I see what your saying, its just I havent got a clue how to make this loop work with my coding, did try to attempt to code a loop but did not work. Is der any examples u can give me!

 

[grnzbra]

Take a look at

Mailing Labels: Many people, one address

in the reports section. There is a pair of nested loops described there. The difference would be that one of your loops would be based on

For Each Object...Next Object

(or something like that) where you check if the object is a checked checkbox and if it is, you process it.