%dim crumb crumb="Continuous-Continuous Master/Detail Forms" Crumb2="Multiple Continuous Forms" crumb1="Two Continuous Subforms Example" %>
Open Email Using SendObject Access Download
User Inactivity Logout VBA Code
Disable Shift Key Demo
Send Email Microsoft Access Tutorial Download (Advanced)
Programming MS Access Security Alternative
Single User Inventory Calculations Download
How To Perform Multi-User Inventory Calculations
Make Dependent Combo Box Code MS Access Tutorial
Union Query (Advanced) Access Tutorial
How To Fill Fields From Combo Box
<% gnum="0308580411" %>
Continuous SubForms Example
Multiple Continuous Subforms
Displaying multiple master form records while at the same time displaying multiple detail records requires a bit of a trick when programming forms. If you try to set the master form as continuous you will usually get an error saying it must be a single record form when you have a detail form set to continuous records.
I'm not sure what the big deal is that causes Microsoft Access to try to prevent the continuous-continuous master-detail form setup. However, the problem is easily overcome as demonstrated in our downloadable Access example.
There are two basic setups for the detail continuous form. The first is to place the detail form in the footer section of the master form. The second setup is to place the detail form at the same logical level as the master form. In this second case you'll need to have a blank form on which to put both the master and detail forms - this is the standard setup when using a tabbed interface so it isn't a big deal.
In our downloadable example we demonstrate both methods - inside the main form and outside the main form. Note the visual basic code which has different requirements for each method.
Are you ready to download our Microsoft Access Continuous-Continuous Forms demo?
More resources for continuous forms on our website:
Dependent Combo Box Download
Microsoft Access Download
Dependent Combo Box in MS Access
MS Access 2003
<% Response.write "Copyright 2000-" & year(now) & " Blue Claw Database Design" %>
MS Access 2013, Access 2010 & Microsoft Office 2007