Home  Fees/Services  Access Examples  Tutorials  Access Download  Articles  Search  Contact  Privacy  Links

Access Form Programming Tutorial
Two Continuous Subforms







Form Subtotal Fields
Master/Detail Forms
NotInList Event
Speed Up Forms
Unbound Form
Change Textbox Height
Get Website Data
Access Audit Trail

Form Query Parameter



Access Forms With Two Continuous Subforms

Continuous Forms for Master and Detail Forms

Have you ever tried to put a subform into a master form and both forms be continuous? Can't be done right?  Here's a simple method for having both forms in continuous view with automatic coordination of records.

Here is the setup for our example: Master Detail Continuous Forms
In this example we have customer orders (types of tee shirts with designs printed on them). Customers may order more than one style of tee shirt in the same order.



Are you just starting out on your quest for a small business database? Need some advice or someone to bounce ideas off of? We are happy to chat with you to discuss options to your situation.

Did you know that most template databases often do not do exactly what you need done? We can create a custom template that fits your needs exactly.


They can also indicate the different sizes they want and the quantities for each.  In the standard for setup you'd only be able to see one of the styles within the order and the associated list of sizes.

With this example method you can show all the  styles and all the size selections for any particular style.  This give you more of a total picture of the order.

Here's the same form in design view:

Access Continuous Forms

The trick is to place the subform in the Footer of the main form.  In this case we have three forms:  1st for the customer; 2nd for the Style Order Items; 3rd for the size/quantity for each style.  So, we insert the 'F_Order_Items_Details' form in the footer of the 2nd form.  Note that the Link Child and Link Master fields are as they normally would be - the index-unique field of the master table and the foreign key to this table as the child link field.

There's no manual coordination of the forms required.

Note that if you get an error:

A form with a subform object can't have its DefaultView property set to Continuous Forms.

Just acknowledge the error and change the parent (master) form back to continuous in the Default View of property sheet and then both master and detail forms will remain as continuous forms.

**NEW**:  Download a running example of the Main Form/Sumform Download at our Access database download center.









A Blue Claw Software Design Template:

Subscription Order Control Database
 








A Blue Claw Database Design Article:

Why Choose Microsoft Access
 









Microsoft Office Forms:
 MS Access 2003
 Access 2007
 Access 2010
 Access 2013




Contact Information

Copyright 2000-2017 Blue Claw Database Design