Hi Richard Can you please post a simple example of vba code to link nodes from child tables For example school/ class/students tables.
Many thanks
Scott Axton
@Reply 3 years ago
Sami the linking is automatically (normally) taken care of by Access if you are using a SubForm. If the fields are not named the same you may have to set the Link Master and Link Child fields manually. This is all dependent on having the right Foreign Key in the associated tables. Many-to-Many
If you don't have it as a SubForm and you are opening a different form using a button for instance, the Where condition of the form is specified with the open event. Like in the Blank Template video.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 20.