取消选中一组复选框 [英] Deselect a Group of Check Boxes

问题描述

下午好，

我想知道是否有人可以指示我如何编写VBA代码来取消选择所有记录的约26个复选框。


我一直在网上搜索，但我没有遇到任何事情。


现在我有一个命令按钮表单，可以取消选择单个记录的一个复选框。我不想将所有复选框名称中的硬编码都写入VBA。


谢谢

Good afternoon,

I would like to know if anyone can direct me as to how I can write a VBA code to deselect about 26 check boxes, for all records.

I have been searching the internet, but I haven''t came across anything.

Right now I have a command button on the form, that is able to deselect one checkbox for a single record. I don''t want to have to hard code in all the checkboxes names into VBA.

Thanks

推荐答案

展开 | < span class =codeLinkonclick =selectAll（this）;>选择 | Wrap | 行号

非常感谢你。现在唯一的问题是它适用于22条记录中的1条。对于每一行（记录），大约有22个复选框，所以实际上，我需要清除大约400个复选框。

Thank you so much. Now the only problem is that it work for 1 out of 22 records. For each row (record), there are about 22 check boxes, so in actuality, I need to clear about 400 check boxes.

展开 | 选择 | Wrap | 行号

为了方便实现，将代码放在窗体的On Current事件中。将表单更改为连续表单视图。然后打开表单。您可以在之后将其更改回来。

For ease of implementation, put the code in the On Current event of the form. Change the form to continous form view. Then open the form. You can change it back after.

这篇关于取消选中一组复选框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！