Are they Identical?
If the sub forms are identical in structure, then you would be far better off changing the record source of the sub-form.
Switch the Forms
However if you indeed have differently structured forms, then it is quite easy to switch in and out the different sub-forms.
"Sub-Form Window"
A subform is not actually presents on your main form, the subform actually exists within a subform subreport/control which I generally referred to as a "Sub-Form Window".
"SourceObject"
This subform/subreport control has a property I believe from memory is called "SourceObject". You can change this source object with VBA. In other words point it at a different form and then that form will be shown within the subform/subreport control.
Parent/Child Relationship
Now one thing to watch out for is that if your forms are not similar, it is then likely that they will have different Fields linked to the main form. The field linking is controlled by a parent/child relationship stored within the subform/subreport control. This parent child arrangement is also modifiable with VBA code.
Example - Time Management Matrix
There's an example on my
Nifty Access website called the Time Management Matrix (Stephen Covey) which demonstrates the use of four sub forms to create the Time Management Matrix. (It actually utilises one form four times)
Get it for FREE!
Click on this link:-
https://gum.co/TimeManMatrix to download the Time Management Matrix, an example that demonstrates how to switch in and out sub-forms, and how to change the sub-forms properties, for example its record source. You can download the time management matrix subform example from here:-
https://gum.co/TimeManMatrix To
get it for FREE use the Coupon Code:- 95r2296
It's "HOT" I need a Beer!
Alternatively don't use the coupon code and buy "Uncle Gizmo" a coffee! ( I might have a beer!)
