形式领域行为难题 [英] Form Field Behaviour Conundrum
问题描述
大家好
我一直在尝试向继承的数据库中的表单添加字段，并且不清楚发生了什么。
I have been trying to add a field to a form in an inherited database and am not clear what is happening.
我复制了一个现有的文本框，并将副本的控制源更改为后端数据库中新创建的字段。
I copied an existing text box and altered the control source of the copy to a newly created field in a back-end db.
表单和控件实际上是基于查询包含新字段的后端表。
The form and the control are actually based on a query on the back-end tables that includes the new field.
当我尝试在新字段中创建条目时，没有任何反应，尽管可以在复制的捐赠字段中输入。 所以我将复制的字段文本框移开了，并创建了一个全新的文本框。 这个控制源我设置为
与复制文本框相同的字段。 我可以在新文本框中输入这些内容，并将它们镜像到原始复制的文本框中。
When I try to make an entry in the new field nothing happens, although entries into the copied donor field are possible. So I moved the copied field text box out of the way and created a whole new text box. The control source of this I set to the same field as the copied text box. I can make entries into the new text box and these are mirrored in the original copied text box.
所以现在我很难找到为什么复制的文本框被锁定以便输入数据因为它显然链接并显示正确的数据。 用于复制的原始文本框将locked属性设置为yes，但数据输入仍然是
。
So now I am struggling to find why the copied text box was locked for data entry as it is obviously linked to and displaying the correct data. The original text box, used to copy from, has the locked property set to yes and yet data entry is still possible.
此表单上的一个功能是能力根据组合框选择锁定某些字段。 可能是导致问题的原因，但我不理解代码。 查看原始捐赠者文本框，它具有更新前属性
：
One feature on this form is the ability to lock certain fields based on a combo box selection. It could be this that is causing the issues, but I don't understand the code. Looking at the original donor text box, it has a before update property of:
私有子pp_code_BeforeUpdate（取消为整数）
通话检查（Me.pp_code）
结束子
Private Sub pp_code_BeforeUpdate(Cancel As Integer)
Call Checking(Me.pp_code)
End Sub
这可能阻止了数据输入...任何人都可以建议找到me.pp_code的位置？  字段名称是pp代码（连字符不是下划线）所以我不确定这是指什么。
This may be what is blocking the data entry... can anyone advise where the me.pp_code will be found? The field name is pp-code (hyphen not underscore) so I'm not sure what this refers to.
任何指针都感激不尽。
谢谢
Phil
推荐答案
嗨Phil，下划线有时指的是空格字符。如果您转到"属性"窗口并单击"控制"下拉菜单，是否会看到"pp代码？"
Hi Phil, The underscore sometimes refers to a space character. If you go to the Properties window and click on the Control drop down, do you see a "pp code?"
这篇关于形式领域行为难题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
