continuous form within continuous form

[maxcess]

Is it possible to make a form look like a continuous cascading outline (kind of like a report can list things under a heading using page header/footer criteria). That suggests a continuous form within a continuous form where the second form can expand and contract between the rows of the main form. Example:

Customer1 Name1 Location1
Room1 Chair1 Pencil1
Room2 Chair2 Pencil2
Customer2 Name2 Location1
Room1 Chair1 ....etc

Rather than needing to see all the customers above with other detail in form below. Example:

CustomerForm (continuous form)
Customer1 Name1 Location1
Customer2 Name2 Location1
etc...

RoomSubform (continuous form linked to CustomerForm with focus on Customer2)
Room1 Chair1 Pencil1


If anyone can answer this question, it will be evidence that God still does love Access database developers

 

[Rich]

Either add a command button which opens your second child form, or drag the subForm to the Continuous form footer

 

[Malcy]

Hi
Not sure if it is quite what you want but in a sort of similar situation I put code in the double click event of one of the fields in a continuous form. On the double click it opened up a new continuous form which expanded upon the details of the record in the first continuous form (using link criteria).
Close the second continuous form and you are back at the original.
Works well for me.
HTH

 

[maxcess]

Tried the subform in the form footer, but the values did not appear to insert themselves between the parent data rows. One was stacked on top of the other. Is that what is to be expected, or were my settings possibly incorrect.

The button idea is a possibility - just trying to avoid mouse clicks.

 

[Rich]

you have to link the Master/Child fields

 

[maxcess]

The master and child are set, but it still looks like master table above and child table below, not interleaved.

 

[Rich]

not sure what you mean, as you scroll the Parent records the child should change accordingly

 

[maxcess]

Indeed it does. But I am looking for interleaving the child form values with the parent form. Like one can do in a report....

Heading1
value1
value2
value3
value4
Heading2
valueA
valueX
value6
Heading3
valueZ
value3...

as opposed to:

Heading1
Heading2
Heading3

value1
value2
value3
value4 ...

...assuming heading one has focus.

I can live with the latter if necessary, but it would be better, of course, to see all the data at once and to be able to manipulate data in view context of other data rather than needing to view dependant data one row at a time......

 

[Rich]

nope, not possible

 

[maxcess]

Thought so. Subform will need to be in footer then. This is where I get the Parameter error that I posted separately now.....

 

[adam_fleck]

This might be a work around to roughly what you want.

Try making your "values" form a datasheet sub-subform of your "headings" form. Make your "headings" form a datasheet subform on some containing form. Not too intelligible, sorry. Outline.zip, though, illustrates what I'm not making a very good job of saying here. It contains an Access 2000 mdb.

 

[maxcess]

Adam, that was intelligible enough. You understand the concept, and the outline.zip was awesome. Because it is a datasheet, however, drop lists and autocomplete are not available, and not much is possible for dressing up the appearance. I have a better grasp of the overall design limits now. Thanks for the help all.

...max

 

[maxcess]

Oop, spoke too soon on the drop list part... looks promising.