从子表单默认值更新表 [英] Update table from subform default value
问题描述
我正在使用Access跟踪分配给人员的属性。我遇到的问题与将房产标记为剩余有关。当它不再使用时。
我有一个有嵌入式子窗体（frmSurplusSubForm）的剩余格式（frmSurplus）。 frmSurplus标识处理属性的组，frmSurplusSubForm是处理多个属性的数据表视图。
我想要一个控制按钮来传递新信息（剩余日期，财产状况等）到原始财产分配表并更新分配给已确定的人员。
frmSurplus绑定到tblSurplussed，并且仅包含与处置该属性的行为有关的信息。 frmSurplusSubForm绑定到属性赋值表（tblPropertyAssignments），该表具有关于每个属性的所有细节，包括受让人。
我知道如何使用通过frmSurplus / frmSurplusSubForm添加的数据更新tblPropertyAssignments，但是还要将分配给该属性的人员的名称更新为SURPLUSSED。没有用户必须选择SURPLUSSED从列表中。任何和所有建议都表示赞赏！
I''m using Access to track property assigned to personnel. The problem that I''ve encountered has to do with marking the property as "Surplus" when it is no longer used.
I have a surplus form (frmSurplus) that has an imbedded subform (frmSurplusSubForm). frmSurplus identifies the group that is disposing of the property, and frmSurplusSubForm is a data sheet view of multiple pieces of property being disposed of.
I would like a control button to pass back new information (date surplussed, condition of property, etc.) to the original property assignment table AND update the person assigned to "SURPLUSSED".
frmSurplus is bound to tblSurplussed, and contains only the information pertaining to the act of disposing of the property. frmSurplusSubForm is bound to the table of property assignments (tblPropertyAssignments) which has all of the specifics about each piece of property, including the assignee.
I know how to update tblPropertyAssignments with data added via frmSurplus/frmSurplusSubForm, but want to also update the name of the person assigned to the property to "SURPLUSSED" without the user having to select "SURPLUSSED" from a list. Any and all suggestions are appreciated!
推荐答案
我正在使用Access来跟踪分配给人员的财产。我遇到的问题与将房产标记为剩余有关。当它不再使用时。
我有一个有嵌入式子窗体（frmSurplusSubForm）的剩余格式（frmSurplus）。 frmSurplus标识处理属性的组，frmSurplusSubForm是处理多个属性的数据表视图。
我想要一个控制按钮来传递新信息（剩余日期，财产状况等）到原始财产分配表并更新分配给已确定的人员。
frmSurplus绑定到tblSurplussed，并且仅包含与处置该属性的行为有关的信息。 frmSurplusSubForm绑定到属性赋值表（tblPropertyAssignments），该表具有关于每个属性的所有细节，包括受让人。
我知道如何使用通过frmSurplus / frmSurplusSubForm添加的数据更新tblPropertyAssignments，但是还要将分配给该属性的人员的名称更新为SURPLUSSED。没有用户必须选择SURPLUSSED从列表中。任何和所有建议表示赞赏！
I''m using Access to track property assigned to personnel. The problem that I''ve encountered has to do with marking the property as "Surplus" when it is no longer used.
I have a surplus form (frmSurplus) that has an imbedded subform (frmSurplusSubForm). frmSurplus identifies the group that is disposing of the property, and frmSurplusSubForm is a data sheet view of multiple pieces of property being disposed of.
I would like a control button to pass back new information (date surplussed, condition of property, etc.) to the original property assignment table AND update the person assigned to "SURPLUSSED".
frmSurplus is bound to tblSurplussed, and contains only the information pertaining to the act of disposing of the property. frmSurplusSubForm is bound to the table of property assignments (tblPropertyAssignments) which has all of the specifics about each piece of property, including the assignee.
I know how to update tblPropertyAssignments with data added via frmSurplus/frmSurplusSubForm, but want to also update the name of the person assigned to the property to "SURPLUSSED" without the user having to select "SURPLUSSED" from a list. Any and all suggestions are appreciated!
如果您认为合适的事件，可以运行insert语句来更改名称。
if there is an event you feel is appropriate, you can run an insert statement to chang the name.
如果您感觉有活动是合适的，你可以运行一个insert语句来改变名称。
if there is an event you feel is appropriate, you can run an insert statement to chang the name.
感谢您的快速回复！< br $> b $ b我一直在努力，但还没有运气。上面的代码似乎更新了所有条目的名称字段。我想只更新添加到剩余表单的记录（由属性序列号标识的每个唯一记录）。
这是我尝试过的一些代码导致运行时错误438 - 对象不支持此属性或方法。
这篇关于从子表单默认值更新表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
