我如何将子窗体链接到主窗体VBA访问中的列表

问题描述:

我有一个要链接到主表单上的列表的子表单,并且如果我更改列表中的值,那么该子表单的内容应该更改为,该怎么做?

I have a subform that I want to link to a list on main form, and If I change the value in list, then the content of subform should be changed to, how can I do this job?

单击子窗体框架并使用链接属性:

CLick on your subform frame and use the link properties:

Link Master Fields应该是您的列表框,而Link Child Fields应该是子窗体中其对应的外键字段.

The Link Master Fields should be your listbox, and the Link Child Fields should be its corresponding foreign key field in the subform.