且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

从另一个子窗体,问题重新查询子窗体

更新时间:2023-10-11 14:02:46

您应该不需要做的筛选器属性什么。

You should not need to do anything with the filter property.

在首体,设置链接主字段和链接子字段属性,你会为一个表单上有规律的,单一的子窗体控件。

On the first subform, set the Link Master Fields and Link Child Fields properties as you would for a regular, single subform control on a form.

对于第二个窗体,还设置了链接子字段属性,你会为一个常规的,单一的子控件。链接主字段属性将引用第一子窗体的控件名称:![1窗体控件名称]字段名

For the second subform, also set the Link Child Fields property as you would for a regular, single subform control. The Link Master Fields property will reference the control name of the first subform: [Subform 1 Control Name]!FieldName.

在第一子窗体控件的成为当前事件,添加VBA code以下行:

In the OnCurrent event of the first subform control, add the following line of VBA code:

Me.Parent.Controls![Subform 2 Control Name].Requery

运行方式。当您单击首体一排,第二子窗体将重新查询,显示该子行的第一子窗体选择的行。

Run the form. When you click a row in the first subform, the second subform will requery to display the child rows for the row selected in the first subform.