访问表单 - 无法输入数据 [英] Access Forms-cannot enter data
问题描述
我的问题与访问表单有关。我已经使用4个不同的表设置了一个Access表单〜我从一个表中提取2个不同的数字和Trusts的名称，我从第2个表中提取保管人名称和帐号，从投资管理器表中提取2个不同的数字然后3个第4个表格中的空字段（此时需要由表单填充）。你能告诉我为什么在表单视图中我无法将数据输入3个空字段。我用于表单的所有表都是可更新的。希望这很清楚。在此先感谢您的帮助。
My question is related to Access forms. I have set up an Access form using 4 different tables~I am pulling 2 different numbers and the name of Trusts out of one table, I am pulling custodian name and acct number from 2nd table, 2 different numbers from Investment manager table and then 3 empty fields (at this time-needs to be populated by form) out of the 4th table. Can you tell me why I am not able to enter data into the 3 empty fields while in form view. All the tables I am using for the forms are updatable. Hope this is clear. Thanks in advance for your help.
推荐答案
它是您的表单所基于的查询。由于某些原因，由于您已设置的条件，它会锁定记录。如果你有相互依赖的关系，这可以解释它。
使用你用来绑定表单的查询。尝试两个然后添加第三个，然后尝试三者的组合来找出问题所在。
Its the query your form is based on. For some reason it locks the record due to the criteria that you have setup. If you have relationships that are dependent on one another this could account for it.
Play with the query you are using to bind your form. Try two then add the third, then try a combination of the three to figure out where the problem is.
它的查询表单是根据。由于某些原因，由于您已设置的条件，它会锁定记录。如果你有相互依赖的关系，这可以解释它。
使用你用来绑定表单的查询。尝试两个然后添加第三个，然后尝试三者的组合来找出问题所在。
Its the query your form is based on. For some reason it locks the record due to the criteria that you have setup. If you have relationships that are dependent on one another this could account for it.
Play with the query you are using to bind your form. Try two then add the third, then try a combination of the three to figure out where the problem is.
我正在使用表来设置表单 - 没有查询 - 数据库中的表运行了查询，但我没有使用它们形式 - 意志仍然会有所不同？
I am using tables to set up the form-no queries-there are queries ran off the tables in the database but I am not utilizing them for the form-will that still make a difference?
但我带你使用控制源来选择多个位置吗？如果是这样也是一个查询，如果不是如何将表绑定到表单？
but i take you are using the control source to select multiple locations right? if so that is also a query, if not how are you binding the tables to the forms?
这篇关于访问表单 - 无法输入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
