Kaja
Reputation: 3057
how do I link a subform to a list in main form vba access
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?
Upvotes: 0
Views: 1084
Answers (1)
Renaud Bompuis
Reputation: 16806
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.
Upvotes: 1
Related Questions
- Linking a sub form
- Creating a query which references a sub form from a sub form
- How to reference a subform in MS Access
- MS Access - Subform navigation
- Referencing Controls in Subforms
- MS Access forms with two subforms linked to the same table
- MS Access 2007/2003 - Referencing a control on a sub form, from the parent form
- How Create an Hyperlink from a sub form to a specific record in a form in Microsoft Access 2007/2010
- MS Access nested subforms link to main (parent) form
- MS Access = referencing a control that is within a sub form