如何检查连续表单上的所有复选框控件？ [英] How do I check all check box controls on a Continuous Form?
问题描述
嗨组，
如何查看连续表格上的所有复选框控件？
我有表格（主要）有两个SubForms（Sub1和Sub2）。 Sub1有一个按钮，用于检查Sub2的SourceObject中可见的所有复选框。 Sub2的SourceObject是一个基于查询的连续表单。
我需要能够单击该按钮并选中所有复选框。
现在，我只能先检查一下！
我想尽可能高效地做到这一点，所以任何帮助都会非常感激！
Oliver
Hi group,
How do I check all check box controls on a Continuous Form?
I have a form (Main) with two SubForms (Sub1 and Sub2). Sub1 has a button that is supposed to check all the check boxes visible in the SourceObject of Sub2. The SourceObject of Sub2 is a Continous Form based on a query.
I need to be able to click the button and have all the check boxes become checked.
Right now, I can only get teh first one to check!
I''m trying to do this as efficiently as possible, so any help would be much appreciated!
Oliver
推荐答案
嗨组，
如何检查连续表单上的所有复选框控件？
我有一个包含两个子表单的表单（Main） （Sub1和Sub2）。 Sub1有一个按钮，用于检查Sub2的SourceObject中可见的所有复选框。 Sub2的SourceObject是一个基于查询的连续表单。
我需要能够单击该按钮并选中所有复选框。
现在，我只能先检查一下！
我想尽可能高效地做到这一点，所以任何帮助都会非常感激！
Oliver
Hi group,
How do I check all check box controls on a Continuous Form?
I have a form (Main) with two SubForms (Sub1 and Sub2). Sub1 has a button that is supposed to check all the check boxes visible in the SourceObject of Sub2. The SourceObject of Sub2 is a Continous Form based on a query.
I need to be able to click the button and have all the check boxes become checked.
Right now, I can only get teh first one to check!
I''m trying to do this as efficiently as possible, so any help would be much appreciated!
Oliver
嗨奥利弗，
如果我没记错的话，你的sub2是sub1的子表单。尝试选择所有按钮。为了在连续表单上执行所需操作，必须将复选框字段绑定到表中的字段。
Hi Oliver,
If I recall correctly, your sub2 is a subform of sub1. Try this for your select all button. In order for you to do what you want on a continuous form, the checkbox field must be bound to a field in your table.
嗨奥利弗，
如果我没记错的话，你的sub2是sub1的子表单。尝试选择所有按钮。为了在连续表单上执行所需操作，必须将复选框字段绑定到表中的字段。
Hi Oliver,
If I recall correctly, your sub2 is a subform of sub1. Try this for your select all button. In order for you to do what you want on a continuous form, the checkbox field must be bound to a field in your table.
您好Puppydogbuddy，
实际上在这种情况下，Sub2与Sub1处于同一级别（我现在正在处理不同的表格）。我会试一试并发送更新，但直到今晚我都不可能达到这个目的。
有没有办法通过与表单交互来实现而不是查询？我喜欢你的方法有多干净，但我只是好奇。如果这对我有用，那么到目前为止它将是数据库中的例外，因为所有其他更改都是通过更改表单的值而不是通过直接编码的SQL语句来完成的。
感谢您的帮助！
Oliver
Hi Puppydogbuddy,
Actually in this case, Sub2 is at the same level as Sub1 (I''m working on a different form now). I''ll give this a shot and send an update, but I won''t likely get to this until tonight.
Is there a way to do this by interacting with the form, instead of the query? I like how clean your method is, but I''m just curious. If this works for me, it will be the exception in the DB so far, as all my other changes have been made by changing the values of forms and not by directly coded SQL statements.
Thanks for the help!
Oliver
虽然我认为只要表单绑定到您的表并且您的按钮包含刷新/重新查询命令，您应该能够通过表单执行上述方法更好，更高效。
Although I think the above approach is better and more efficient, you should be able to do it thru the form as long as the form is bound to your table and your button includes a refresh/requery command.
这篇关于如何检查连续表单上的所有复选框控件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
