Apr 20 2012, 01:44 PM
I've got a continuous form, onto which I'd like to place a continuous subform, but of course Access doesn't like that. has anyone come up with a workaround for this sort of thing?
Apr 20 2012, 01:47 PM
I don't think that's possible.
Why would you like to have that kind of design?
Apr 20 2012, 02:24 PM
It is not possible to put a subform onto the detail section of a continuous form, however, you can put the sub form in the header or footer of a continuous form.
My personal preference is to use 'single form view' and use a list box to select the required record. Then use the list box as the master in the sub form master child link.
Apr 20 2012, 09:47 PM
QUOTE (pere_de_chipstick @ Apr 20 2012, 03:24 PM)
...It is not possible to put a subform onto the detail section of a continuous form, however, you can put the sub form in the header or footer of a continuous form.
As Bernie said, the workaround for having a Subform
when the Main Form
is in Continuous View
requires that you put the Subform
either in the Header
or the Footer
of your Main Form
. To escape the wrath of the Access Gnomes you have to:
- Create your Main Form in Single Form View
- Place the Subform in Header or Footer, whichever you like
- Save the Form
- Now go into Properties and change the Main Form's Default View to Continuous View Form
Apr 21 2012, 01:46 PM
This is amazing! I joined just a few hours ago to look for a solution to this exact problem. Thanks guys !
Apr 21 2012, 02:21 PM
You're welcome, and
Apr 23 2012, 07:43 PM
Thanks all. I was afraid of that.
The reason for doing it this way is just to give users a little more display information on the form, so they don't have to open up a detail form, but rather get an overview of many records and their subrecords.
Apr 23 2012, 11:33 PM
There are many structural workarounds.
Another uses a single main form containing two Continuous subforms.
Place a textbox on the mainform with the ControlSource as the field or control in the first subform you want to track.
Then enter this textbox as the LinkMaster of the second subformcontrol.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here