Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Check boxes
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Check boxes
Resolved · High Priority · Version 2003
Reply Thu 4 Sep 2008, 17:40Delegate Chloe said...
Chloe has attended:
Access VBA course
Check boxes
Hi I have a form which has multiple check boxes. I have a list of labels that are named chkjob1, chkjob2...chkjob6,
I would like to create a function that checks all the check boxes for a job when the label is selected/clicked. so once you click on a the label for the job e.g jobA and hit run the details of the job (jobA) will be passed into the fuction which would have an array that would build the names of check boxes and select the row.
eg
form
if label JobA is selected then
pass jobA into the function ()
Function()
chk & jobA & (i)
= chkJobA1. value = true <name of check box>
repeat for all six check boxes.
Please email me if you do not understand what I mean.
I want a seperate fuction so that it can be used for multiple jobs, without endless code.
Many Thanks
Chloe
For upcoming training course dates see: Pricing & availability
RE: check boxes
Hi Chloe
Thanks for the question.
Because you have named your check boxes in a numeric sequence you can use a for loop to walk through them and populate your array.
Dim iCounter As Integer
Dim Jobs(4) As Boolean
For iCounter = 1 To 4
Jobs(iCounter) = Me.Controls("chkjob" & iCounter).Value
Next iCounter
I hope that helps.
Laura GB
|