更新时间: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.