用表格更新表格 [英] updating tables with forms
问题描述
大家好。
我是Access的完全新手。我已经创建了一组带有嵌套子表单的表单，虽然很可爱（我也是），但完全没有功能（嘘）。
似乎有两个问题，但是我我不能完全确定我没有看到同样问题的两种表现形式。
1.我绑定的组合框和列表框不允许我选择其中的任何选项。 （值得注意的是，我的值是从与写入的表不同的表中提取的。）
2.没有数据写入表中。
我已经检查过锁定了和启用领域。我猜我应该在某个地方有更新声明，但我不知道在哪里。
谢谢。
Elaina
在数据选项卡下的组合和列表框的属性中。检查控制源设置的内容（我什么都不猜;））。
如果我是对的，只需在每种情况下选择要存储的字段价值。
玛丽
大家好。
我是Access的完全新手。我已经创建了一组带有嵌套子表单的表单，虽然很可爱（我也是），但完全没有功能（嘘）。
似乎有两个问题，但是我我不能完全确定我没有看到同样问题的两种表现形式。
1.我绑定的组合框和列表框不允许我选择其中的任何选项。 （值得注意的是，我的值是从与写入的表不同的表中提取的。）
2.没有数据写入表中。
我已经检查过锁定了和启用领域。我猜我应该在某个地方有更新声明，但我不知道在哪里。
谢谢。
Elaina
在你的组合和列表框的属性下数据选项卡。检查控制源设置的内容（我什么都不猜;））。
如果我是对的，只需在每种情况下选择要存储的字段价值。
玛丽
啊......你不认识我，但我很喜欢比那更棘手。 （插入邪恶的笑声。）控制源已经正确设置。抱歉。我希望这很容易。还有另一个人有类似的问题，但他自己解决了这个问题而没有详细描述白痴我。我也回复了那个， http://www.thescripts.com/forum/thread537788.html
谢谢。
Elaina
问题：
你的表格记录来源是什么？如果它是一个查询它可能是不可更新的。发布查询的完整sql代码。
组合框和列表框的行源和行源类型是什么？
Mary
Hi all.
I am a complete newbie to Access. I''ve created a set of forms with nested subforms which while lovely (Yay me), are completely non-functional (boo).
There seem to be 2 problems, but I can''t be completely sure that I''m not seeing 2 manifestations of the same problem.
1. My bound combo and list boxes will not allow me to select any of the options in them. (of note, my values are being drawn from a different table than they are being written to.)
2. No data is being written to the tables.
I''ve checked the "locked" and "enabled" fields. I''m guessing that I should have an update statement somewhere, but I don''t know where.
Thanks.
Elaina
In the properties of your combo and list boxes under the data tab. Check what the control source is set to (I''m guessing nothing ;) ).
If I''m right just select in each case the field in which you want to store the value.
Mary
Hi all.
I am a complete newbie to Access. I''ve created a set of forms with nested subforms which while lovely (Yay me), are completely non-functional (boo).
There seem to be 2 problems, but I can''t be completely sure that I''m not seeing 2 manifestations of the same problem.
1. My bound combo and list boxes will not allow me to select any of the options in them. (of note, my values are being drawn from a different table than they are being written to.)
2. No data is being written to the tables.
I''ve checked the "locked" and "enabled" fields. I''m guessing that I should have an update statement somewhere, but I don''t know where.
Thanks.
Elaina
In the properties of your combo and list boxes under the data tab. Check what the control source is set to (I''m guessing nothing ;) ).
If I''m right just select in each case the field in which you want to store the value.
Mary
Ah... you don''t know me, but I''m wayyy trickier than that. (insert evil laugh.) The Control sources are set correctly already. Sorry. I wish it were that easy. There is another person who had a similar problem, but he solved it on his own without describing in enough detail for idiot me. I replied to that one as well, http://www.thescripts.com/forum/thread537788.html
Thanks.
Elaina
Questions:
What is your forms record source bound to? If it''s a query it''s possible it''s not updateable. Post the full sql code for the query.
What are the Row Sources and Row Source Types for your combo and list boxes?
Mary
这篇关于用表格更新表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
