Full Version: Workaround For Continuous Subform On Continuous Form?
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
Harfleur
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
I don't think that's possible.
Why would you like to have that kind of design?
pere_de_chipstick
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
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
This is amazing! I joined just a few hours ago to look for a solution to this exact problem. Thanks guys !
pere_de_chipstick
You're welcome, and

welcome2UA.gif
Harfleur
*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
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.