Subform in continous form
Today we can't use a subform in a continous form.
Ernesto Manríquez Mendoza commented
Just put your subform in the footer or the header of the form containing a continuous form. Don't use the wizard; just do it and set the source and the linked fields manually.
It is undocumented, but it works amazingly. I can send you videos of my app taking advantage of this.
Dale Fye commented
I get so frustrated by not being able to put a subform in a continuous form, the way I can with reports/sub-reports. The work-arounds for this are simply ugly.
Alan Cossey commented
Remember you can also have subdatasheets to your datasheets as well. You can't have headers and stuff to the datasheet, but you could put the datasheet on a top-level form so you have the datasheet as your subform and then the subdatasheet runs off that.
As Kent said, you can, in fact, have a Subform when the Main Form is in Continuous View...you simply need to fool the Access Gnomes in order to do this! The workaround requires that you put the Subform either in the Header or the Footer of your Main Form.
You need to:
Create your Main Form in Single Form View
Place the Subform in Header or Footer Section, whichever you like
Save the Form
Now go into Properties and change the Form's Default View to Continuous
Daniela Juessen commented
That would be fantastic. I need it quite often and always have to program work-arounds. Oracle forms is quite capable of doing that even nested unlimited times.
Michelle Keener commented
I have had to create a work-around for the 'subform within continuous form' in the past. Although it works, it required a great deal of programming and is not as quick as I would like it to be. Having a subform within continuous form would be a huge improvement.
Anthony Griggs commented
Crystal Reports allows you to place Sub Forms within the Detail!
As critical as I am of MS Access and the way it treats the programmer/consultant, this is business of subforms and sub-subforms is an AWESOME capability. Offhand I do not know of any other software platform that can do this. Simple example: if you have two bank accounts at the same bank and you visit them on the web, you can see only one a ta a time in a given window. My meandering point is, if the Access team can bring this to fruition, it would be fantastic!
Despite the warning, you can put a subform in the Footer of a continuous form.
Just not in the detail section so you can only see the children of the current record.
[Deleted User] commented
That would be awesome!