MS Access-更改表格中的值后立即写入表 [英] MS Access - Write to Table Immediately After Changing Value in Form

问题描述

在更改表单中的值时，是否有一种方法可以使Access立即将值写到表中?现在，我必须更改表单中的值，然后在将该值写入对应的表之前，在该子表单上单击该字段.

Is there a way to make Access write values immediately to a table when changing values in a form? Right now, I have to change a value in the form, and then click off the field onto the subform before the value is written to the corresponding table.

听起来没什么大不了的，但是某些控件需要当前数据才能提供有效的选项.如果用户对单击子窗体的了解不足，那么他们查看的数据可能已过时.

Sounds like no big deal, but certain controls require current data to give valid options. If the user doesn't know enough to click into the subform then the data they view could be out-of-date.

推荐答案

如果要匹配组合框，则可以将其用作链接主字段，即控件本身的名称.一旦您选择带有组合的票证，您的子表单就会更新.

If you are matching a combo box, you can use that as your link master field, that is, the name of the control itself. Your subform should update as soon as you select a ticket with the combo.

Link Master Fields: Combo1
Link Child Fields:  Field1

这篇关于MS Access-更改表格中的值后立即写入表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！