This is a very nice subform example in MS Access. You can easily create the tables and code yourself without having to pay for it, - by just following the video. Why not save yourself a bit of time & trouble, download it, ready made!
I use this video in at least two blogs on my website, one on Subforms here:- http://www.niftyaccess.com/sub-forms/
And the other blog on Many to Many Relationships here:- http://www.niftyaccess.com/many-to-many-relationship/
I demonstrate creating the Student Form (The Master Form) On this form is placed the sub-form which relates the hobbies to each student. The many-to-many table which stores the relationship between the student and hobbies (and vice versa) only contains integers (numbers) so I also demonstrate how to change the textbox on the subform which is displaying the reference number to the hobby into a combobox and get the Combo to show the corresponding text description of the item with a look up..
- Size61.3 KB