Mulitple Check Boxes

[kod2th3e]

I have a form with 5 check boxes and a command button. When I click the command button I want it to determine what check boxes are clicked and add the captions together in a string.

chkbox1.caption "Hand Solder"
chkbox2.caption "Mini Wave"
chkbox3.caption "X-Ray"
chkbox4.caption "Connector Replacement"
chkbox5.caption "Heat Gun"

So if I have a variable strprocess and I click the command button I want it to determine which of the above is checked (lets say chkbox1 and chkbox2) and make strprocess = chkbox1.caption & chkbox2.caption with a comma in between (Hand Solder, Miniwave). Any ideas/thoughts? Thanks for looking.

 

[sous2817]

not test but something like

strprocess = ""
If chkbox1.value = true then strprocess = chkbox1.caption & ","
if chkbox2.value = true then strprocess = strprocess & chkbox2.caption & ","
if chkbox3.value = true then strprocess = strprocess & chkbox3.caption & ","

etc, etc, etc

You may have to work out some logic if only one option is checked to get rid of any trailing ",", but it should get you started.

 

[kod2th3e]

Sorry for the delayed response, that was perfect. Thanks so much for your time and help.

-Cody