how do I link a subform to a list in main form vba

2019-09-09 17:34发布

问题:

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?

回答1:

CLick on your subform frame and use the link properties:

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