使用复选框选择记录，将数据发送到Tbl [英] Use Checkbox to select record, Send data to Tbl
问题描述
谢谢你的时间。我是新手用户;但是，这是我的目标。
我有一个包含2个级联组合框和一个子表单的表单。
我希望子表单列出来自它表的所有记录，并在与组合框对应的记录上选中复选框。
表格：KB_Overview（绑定到Project_Desc）
Combobox：ProjList（与表格相同的查询未绑定）
子表单：基于表（Knowledge_Divisions），包括复选框
父和子字段：KD_ID
我希望子表单显示其表中的所有行（Knowledge_Divisions ）和对应于主窗体记录（Project_Desc.Project_Name）的记录上选中的复选框。例如，如果表Project_Desc的KD_ID = 5;然后，子窗体应该选中第5行的复选框。
另外，我希望能够更改复选框然后，我认为，更新后更改相应主表中的记录。
非常感谢任何见解。如果我能提供更多信息，请告诉我。
Hi, thanks for your time. I am a novice user; but, here is my goal.
I have a form with 2 cascading combo boxes and a subform.
I want the subform to list all records from it''s table, and have the check box checked on the record that corresponds to the combobox.
Form: KB_Overview (bound to Project_Desc)
Combobox: ProjList (unbound with query to same table as form)
Subform: based on table (Knowledge_Divisions) that includes checkbox
Parent and Child field: KD_ID
I would like the subform to display all rows from its table (Knowledge_Divisions) and the check box selected on the record that corresponds to the main form record (Project_Desc.Project_Name). For example if the table Project_Desc had a KD_ID that =5; then, the subform should have row 5''s check box checked.
Also, I would like to be able to change the check box and then, I assume, an after update to change record in corresponding primary table.
Thanks so much for any insight. Please let me know if I can provide more information.
推荐答案
你说你想要子窗体显示其表格中的所有行（Knowledge_Divisions）。你不是说你希望它显示所有与主窗体ID相匹配的行吗？
你是否知道子窗体和主窗体可以链接在一起子表单只显示与表项Project_Name具有相同ID的Knowledge_Divisions中的行？
您想在主表中更改什么？你在子表单中的一个（可能）行上检查一个框 - 一些行被检查，一些不是......你想在主表中根据其中一个sub改变什么-form rows已被检查？
Jim
You say you want "the subform to display all rows from its table (Knowledge_Divisions)". Don''t you mean you want it to display all rows that match the main form''s ID?
Are you aware that the subform and the main form can be linked so that the subform shows only the rows from Knowledge_Divisions that have the same ID as table Project_Name?
What do you want to change in the primary table? You check a box on one of (potentially) several rows in the sub-form - some of the rows are checked, some are not ... what do you want to change in the primary table based on the fact that one of the sub-form rows has been checked?
Jim
一些问题：
- 您是否需要子表单或详细信息部分是否适合您？
- 当您参考在你的例子中记录＃5，你是说列表中的第五个还是那个ID为5的那个？
这篇关于使用复选框选择记录，将数据发送到Tbl的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
