如何释放表单之间的记录锁定？ [英] How to release the record lock between forms?
问题描述
我有一个表格，患者，有两个子表格：
- 人口统计资料（与患者一对一的关系）
- 帐户（许多帐户代表单个患者）
帐户允许修改部分帐户领域。它有一个按钮，可以打开一个单独的表单，提供一组不同的字段进行修改（用于在打印的表格上报告Medi-Cal18-1，因此，辅助表格'的名称，就像你'将在下面的代码中看到。
问题是记录锁定是否保持设置。这是当前的代码：
I have a form, Patients, that has two subforms:
- Demographics (one-to-one relationship with Patients)
- Accounts (many accounts for a single Patients)
Accounts allows modification of some of the account''s fields. It has a button that opens a separate form, which offers a different set of fields for modification (used for reporting to Medi-Cal on their printed form "18-1", hence the secondary form''s name, as you''ll see in the following code).
The problem is the record lock is remaining set. Here''s the current code:
推荐答案
嗨苏
两种表格的记录来源是什么？
您以何种方式确定记录锁定？您是否只是无法编辑记录或者您收到错误消息？
Hi Sue
What the recordsource for both forms?
In what way do you determine that the recordlock is set? Are you simply unable to edit the record or are you getting an error message?
我今天不在我的电台，但我确定我使用相同的查询两种形式（这是一个新的数据库，我只创建了2-3个查询）。
而且，是的，我确定这是因为我无法修改 18-1 表格中的任何未锁定控件。
I''m not at my station today, but I''m sure that I use the same query for both forms (this is a new database and I''ve created only 2-3 queries).
And, yes, I determine this by the fact that I can''t modify any of the unlocked controls on the 18-1 form.
这里有几种可能性。
一是你已经积极设置页面或表lvl锁定你的查询（我没有太多的经验）
另一个是你打开子表单之前弄脏了你的主表单。
另一个是你创建了一个不可更新的记录集。
Well there are several possibilities here.
One is that you have actively set page or table lvl locking on your query (which I dont have much experience with)
Another is that you have dirtied your main form, before opening the sub form.
Another is that you have created a recordset that is not updatable.
这篇关于如何释放表单之间的记录锁定？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
