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
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.
Microsoft Access is a fully capable database and it's primary limitations is the number of concurrent users it will support. Generally, we recommend a limit of 10 to 15 users.
We create databases large and small. Some of our databases help run entire small businesses. We also handle unique businesses such as flyrod manufacturing, cheese making, marina management, and cable tv inventory.
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
Copyright 2000-2017 Blue Claw Database Design
MS Access 2013, Access 2010 & Microsoft Office 2007