Dale James
asked on
MS ACCESS: Loop through each checkbox in tabcontrol page
Hello Team
I have a userform which contains a tabcontrol with seven pages. On page 7 (6) there are nine checkboxes.
What I require is that, when the user selects to save the record, code is triggered that checks to identify if at least one checkbox as been selected. If one is identified then the save is allowed to proceed If after all the checkboxes have been analysed and no checkboxes have been selected then the user will be alerted that no checkboxes have been selected and then exist it the save procedure.
Form Name: frmRewnalAudit_Bus
TabControl Name: TabCtlCats
Page Number 7 (6) Page tab is named 'Doc Check'
Each check boxes follows the sequence, Check1, Check2, Check3 etc
Ideally, for example, what I am looking for is, code to loop through checkbox which contains the left string 'Check' and once a true value is identified, exit the loop procedure and execute the save code or after all checkboxes have been looped and no true value has been identified, exit the save routine.
Thank you in advance.
Dale
I have a userform which contains a tabcontrol with seven pages. On page 7 (6) there are nine checkboxes.
What I require is that, when the user selects to save the record, code is triggered that checks to identify if at least one checkbox as been selected. If one is identified then the save is allowed to proceed If after all the checkboxes have been analysed and no checkboxes have been selected then the user will be alerted that no checkboxes have been selected and then exist it the save procedure.
Form Name: frmRewnalAudit_Bus
TabControl Name: TabCtlCats
Page Number 7 (6) Page tab is named 'Doc Check'
Each check boxes follows the sequence, Check1, Check2, Check3 etc
Ideally, for example, what I am looking for is, code to loop through checkbox which contains the left string 'Check' and once a true value is identified, exit the loop procedure and execute the save code or after all checkboxes have been looped and no true value has been identified, exit the save routine.
Thank you in advance.
Dale
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your quick response and suggestions.
Both suggestions provided worked perfectly...much appreciated to you both.
Sincerely
Dale