Is it possible to embed a subform in a continuous form?
The continuous form contains a list of books.
Subform 1 is a list of categories assigned to the book.
Subform 2 is a list of authors for the book.
When record pointer moves from one book to another, the subforms update the categories and authors accordingly.
Is it doable in Access 2007?
Armstrong
![]() |
There are isolated problems with current patches, but they are well-known and documented on this site. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
How to Embed a Subform in a Continuous Form
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » How to Embed a Subform in a Continuous Form
- This topic has 9 replies, 3 voices, and was last updated 15 years, 10 months ago.
AuthorTopicWSarmsys
AskWoody LoungerJuly 21, 2009 at 5:19 am #461361Viewing 0 reply threadsAuthorReplies-
WSHansV
AskWoody LoungerJuly 21, 2009 at 7:01 am #1170238You can’t place a subform in the detail section of a continuous form.
You can place a subform in the form footer (or form header) of a continuous form, and link it to the main form as usual. As the user scrolls through the records of the continuous form, the subform will display the corresponding records.
Another option is to place the continuous form and the “subforms” side by side in the detail section of an unbound main form. You’d have to link the “subforms” to a control on the continuous form, which can be a bit tricky, but it does work.
-
WSarmsys
AskWoody LoungerJuly 21, 2009 at 7:15 am #1170242You can’t place a subform in the detail section of a continuous form.
You can place a subform in the form footer (or form header) of a continuous form, and link it to the main form as usual. As the user scrolls through the records of the continuous form, the subform will display the corresponding records.
Another option is to place the continuous form and the “subforms” side by side in the detail section of an unbound main form. You’d have to link the “subforms” to a control on the continuous form, which can be a bit tricky, but it does work.
Hi Hans,
Before reading your reply, I’ve already done the 1st approach you suggested. Yes, my subforms are placed in the header. I will take some time to try out your 2nd approach.
The reason I raised the question is Access 2007 always issues warning whenever I insert subforms in the header/footer. In addition, Access changes the Default View from Continuous Forms to Single Form automatically. That led me to believe that Access may not support subforms being embedded in the continuous form.
In fact, the Default View (property) can be manually changed back to Continuous Forms.
Thanks for your help.
Armstrong -
WSHansV
AskWoody LoungerJuly 21, 2009 at 9:23 am #1170258Yes, Access changes the default view back to single form if you place a subform anywhere on a continuous form, but it the subform is placed in the form header or footer, you can easily change it back. You can’t do that if you place the subform in the detail section.
This behavior has been the same in all versions of Access as far as I know.If you place subforms side by side, the Link Master Fields property of the second subform will look like FirstSubForm!RelevantControl where FirstSubForm is the name of the first subform as a control on the main form, and RelevantControl is the name of the control bound to the field that you want to link to.
You can’t use the builder/wizard to set the Link Master Field property in this situation, you must set it manually.
-
-
-
WSarmsys
AskWoody LoungerJuly 21, 2009 at 6:04 pm #1170344Another option is to place the continuous form and the “subforms” side by side in the detail section of an unbound main form. You’d have to link the “subforms” to a control on the continuous form, which can be a bit tricky, but it does work.
Though I’m contented with the header/footer placement (as shown in the screenshot), I’m obsessively intrigued by your side-by-side solution. Alas, forgive my ignorance. I have trouble to understand and implement it. In particular, I have trouble to understand the above quoted paragraph.
Questions:
1. Why does it mean by “to place the continuous form and the subforms side by side in the detail section of an unbound main form.
2. By “unbound main form,” does it mean the main form isn’t bound to any dataset/recordset?
3. Would you be exceedingly generous enough to create a sample database to help my troubled learning?3 tables
Table A: BookID, BookTitle
Table B: BookID, Category
Table C: BookID, Author
Both Table B & C are related to Table A by BookID.Thanks a lot.
Armstrong
Edited: 7/22/2009 Wed 09:47:10 AM HKT
Q1 should read: What does it mean by “to place the continuous form and the subforms side by side in the detail section of an unbound main form”?
Sorry for my typo. -
WSjohnhutchison
AskWoody LoungerJuly 21, 2009 at 7:37 pm #1170349Questions:
1. Why does it mean by “to place the continuous form and the subforms side by side in the detail section of an unbound main form.
2. By “unbound main form,” does it mean the main form isn’t bound to any dataset/recordset?
3. Would you be exceedingly generous enough to create a sample database to help my troubled learning?Q2: Yes. In 2007 Create …Form Design does this for you.
Q1: to put things side by side, you need a container to hold them. An unbound form does that job.
But I often do this where the Main container form is not unbound. In the screenshot below, the main form is about Medical Practices. For each practice I want to have multiple communication records, but each of these is about multiple doctors. So in this case I have used the side-by-side solution.I am always concerned when I do this that people will attach records (at the side) to the wrong master record. So in this case I use the pink/red rectangle to reinforce the current record, and I also display Date/time of the current call is also display at the top of the form on the right.
Q3. I haven’t time at the moment. Can you post your books database? Someone could add a side by side example to that, without having to start again.
-
WSarmsys
AskWoody Lounger -
WSarmsys
AskWoody Lounger -
WSHansV
AskWoody LoungerJuly 28, 2009 at 6:28 am #1171302Open the main form in design view.
Arrange the database window and the form window so that you can see both.Drag a form from the database window and drop it onto the main form to add it as a subform.
Move the subform to the position where you want it.
Repeat the above steps for the other subform. -
WSarmsys
AskWoody LoungerJuly 28, 2009 at 6:42 am #1171304Open the main form in design view.
Arrange the database window and the form window so that you can see both.Drag a form from the database window and drop it onto the main form to add it as a subform.
Move the subform to the position where you want it.
Repeat the above steps for the other subform.Wow, it’s that simple. It works brilliantly. Thanks for your rapid rescue. It took me a week struggling for the solution in vain.
Armstrong
-
-
-
Viewing 0 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
MS Excel 2019 Now Prompts to Back Up With OneDrive
by
lmacri
2 hours, 46 minutes ago -
Firefox 139
by
Charlie
2 hours, 2 minutes ago -
Who knows what?
by
Will Fastie
32 minutes ago -
My top ten underappreciated features in Office
by
Peter Deegan
23 minutes ago -
WAU Manager — It’s your computer, you are in charge!
by
Deanna McElveen
12 hours, 39 minutes ago -
Misbehaving devices
by
Susan Bradley
2 hours, 31 minutes ago -
.NET 8.0 Desktop Runtime (v8.0.16) – Windows x86 Installer
by
WSmeyerbos
1 day, 6 hours ago -
Neowin poll : What do you plan to do on Windows 10 EOS
by
Alex5723
1 hour, 39 minutes ago -
May 31, 2025—KB5062170 (OS Builds 22621.5415 and 22631.5415 Out-of-band
by
Alex5723
1 day, 4 hours ago -
Discover the Best AI Tools for Everything
by
Alex5723
4 hours, 5 minutes ago -
Edge Seems To Be Gaining Weight
by
bbearren
19 hours, 10 minutes ago -
Rufus is available from the MSFT Store
by
PL1
1 day, 3 hours ago -
Microsoft : Ending USB-C® Port Confusion
by
Alex5723
2 days, 6 hours ago -
KB5061768 update for Intel vPro processor
by
drmark
5 hours, 52 minutes ago -
Outlook 365 classic has exhausted all shared resources
by
drmark
4 hours, 35 minutes ago -
My Simple Word 2010 Macro Is Not Working
by
mbennett555
2 days, 1 hour ago -
Office gets current release
by
Susan Bradley
2 days, 4 hours ago -
FBI: Still Using One of These Old Routers? It’s Vulnerable to Hackers
by
Alex5723
3 days, 18 hours ago -
Windows AI Local Only no NPU required!
by
RetiredGeek
3 days, 3 hours ago -
Stop the OneDrive defaults
by
CWBillow
3 days, 19 hours ago -
Windows 11 Insider Preview build 27868 released to Canary
by
joep517
4 days, 5 hours ago -
X Suspends Encrypted DMs
by
Alex5723
4 days, 7 hours ago -
WSJ : My Robot and Me AI generated movie
by
Alex5723
4 days, 7 hours ago -
Botnet hacks 9,000+ ASUS routers to add persistent SSH backdoor
by
Alex5723
4 days, 8 hours ago -
OpenAI model sabotages shutdown code
by
Cybertooth
4 days, 8 hours ago -
Backup and access old e-mails after company e-mail address is terminated
by
M W Leijendekker
3 days, 21 hours ago -
Enabling Secureboot
by
ITguy
4 days, 4 hours ago -
Windows hosting exposes additional bugs
by
Susan Bradley
4 days, 16 hours ago -
No more rounded corners??
by
CWBillow
4 days, 12 hours ago -
Android 15 and IPV6
by
Win7and10
4 days, 2 hours ago
Recent blog posts
Key Links
S | M | T | W | T | F | S |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 |
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.