Harfleur
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?
Thanks,
Eric
dipetete
Apr 20 2012, 01:47 PM
I don't think that's possible.
Why would you like to have that kind of design?
pere_de_chipstick
Apr 20 2012, 02:24 PM
Hi Harfleur
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.
hth
missinglinq
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
Linq
;0)>
RichardK
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 !
pere_de_chipstick
Apr 21 2012, 02:21 PM
You're welcome, and
Harfleur
Apr 23 2012, 07:43 PM
*Sigh*
Thanks all. I was afraid of that.
dipetete--
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.
Galaxiom
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.
eg
=subformcontrol.Form.controlname
=subformcontrol!fieldname
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.