<%dim crumb crumb="Continuous-Continuous Master/Detail Forms" Crumb2="Multiple Continuous Forms" crumb1="Two Continuous Subforms Example" %> Master-Detail Continuous Forms Download
Home  Fees/Services  Access 2010 Template  Access Tutorial  Access Download  Articles  Search  Contact  Privacy  Links

<%if len(crumb2)>2 then response.write crumb2 else response.write ">

Open Email Using SendObject Access Download

User Inactivity Logout VBA Code

Disable Shift Key Demo

Send Email Microsoft Access Tutorial Download (Advanced)

Sequential Counter in Query

Multi Select List Box Query Parameters

Row Level Data Security

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 Example (Simple)

Union Query (Advanced) Access Tutorial

How To Fill Fields From Combo Box

Use Global Variables as Parameters

Continuous Form Dependent Combo Box

How To Program Continuous-Continuous Master/Detail Forms

Access Bar Chart / Bar Graph

Programming Crosstab Query Example

TransferText & OutputTo Microsoft Access

DoCmd.OpenForm & OpenArgs VBA Example

Running Sum Query Method

Choose Command Dynamic SQL Order By

Access Conditional Format

Access Report Banding

Popup Form Control Method

<% 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?

Subform examples in Access

More resources for continuous forms on our website:

Continuous Form Dependent Combo Box Download
We haven't come up with a truly seamless solution but we have managed to use a small trick to make the continuous form dependent combo box work.

Microsoft Access Download
If you are searching for this continuous form combo box solution then you Here we have a working database showing continuous-continuous forms with a ...

Dependent Combo Box in MS Access
This technique works great on single record forms. However, on continuous forms we have some additional work to do. See that next method in a future update.


Microsoft Office:
MS Access 2003
Access 2007
Access 2010
Access 2013
Access 2016
<% dim rnum Randomize rnum = Int(Rnd * 10) + 1 response.write " Updated On " & now-rnum %>

Contact Information

<% Response.write "Copyright 2000-" & year(now) & " Blue Claw Database Design" %>

MS Access 2013, Access 2010 & Microsoft Office 2007