Sub-Forms

Sub-Forms

Sub-Forms

Subforms are the best and most useful feature of MS Access. Why? Because they allow you to show related data easily.

I think subforms are so important and useful that I wrote a blog about them here:-

Subforms can easily display parent/child related data. This is the most common and useful feature.

They can also show standalone data, often filtered with a/ combobox(s) and other controls.

But wait a minute actually we are not talking about a subform here, there’s no such thing as a subform, what you’ve actually got is a strangely named control a “subform/subreport control”

The best way to describe this control is to call it a window on your form which looks into another form. I find it’s best to refer to it as a subform window!

Now we got that out of the way we can see the next use you can put the subform to, you can swap forms in and out of it. This window is capable of displaying different forms.

Over the years I have tried in various blogs and YouTube videos to explain subforms. I have never been entirely happy with my various attempts because they always seem to be lacking in something.

For sometime I have been planning to do a comprehensive Blog on Sub-Forms to try and correct this.

Since discovering this excellent blog by Microsoft:-  “Create a form that contains a subform (a one-to-many form)”  Found in this post:-  “Attempting to set subform data from on Current event on Main Form”  on  (AWF) Access World Forums.   I can see there is no longer a need for me to write a blog, because this Blog just about says it all.

My efforts will be far better placed in helping interpret this Microsoft blog, commenting on it, add extra info & code and enhance it with some YouTube videos. My first video “Subform Intro” is designed to whet your appetite.

Further Videos from my YouTube Channel will be added to this Blog page, with sections applicable to the Microsoft Blog highlighted…

… …

Subform - Intro

Subform - Intro

Video 1 (3:50)

This is the first video in my Blog on Subforms. I just want to whet your appetite and give you some idea of what can be done with Sub-forms! In this video I demonstrate how you can modify the SQL statement of a single subform displayed “FOUR TIMES” on a main form! This means you only have two forms, but it looks like you have five! Look at the advantages of approaching things this way. If you’d gone the route of having four separate “IDENTICAL”Forms displayed on your main form, and you wanted to make a subtle alteration you may find yourself editing every single form in your set of duplicates. However by providing different functionality to each instance of a SINGLE FORM with VBA code, you only need maintain that one form.

Video 1 (3:50)

..             ….                ….                     ..                  ..                 . .                  …                   ….              ..               .               …             .. .          .. .. .                 ….

… …

Adding Hobbies to a Student Database

Master & Sub-Form

Video 2  (4:35)

In 5 Minutes, I demonstrate a “Student and Hobby” relationship.  In particular you will see how to set up a Main Form & Subform arrangement for handling and modifying, adding and editing the Data..

This video is also in my Many to Many Blog where the Video demonstrates one side of a Many to Many Relationship.

Video 2  (4:35)

More Info on Hobbies/Student :-

Insert File

Add to “Insert File” Add to “Insert File” Video 1 (0:40) In this video clip I demonstrate how easy it is to add and modify code

Read More »

More Useful Stuff HERE:-