Expanding subdatasheets

[J. Ridenour]

I have a multi-level datasheet form. The main form has a subform, and that
subform also contains a subform ... 3 levels.

I'd like to be able to expand the BOTH LEVELS for a SINGLE record using VBA.

The the form's property of SubdatasheetExpanded expands the subdatasheet for
ALL records (not what I want) and only on the form that it is called for.

Does anyone know how to do this using VBA??

 

[Perry]

What do you mean by

I'd like to be able to expand the BOTH LEVELS for a SINGLE record using
VBA.

Usually, if yr datamodell is ok and yr main-/sub-/subsubform design is ok,
it will
narrow down records and only show related records to the selected record on
yr mainform ...

--
Krgrds,
Perry

System:
Vista/Office Ultimate
VS2005/VSTO2005 SE

 

[J. Ridenour]

The data model is fine and the form's main/sub/subsub form are currently
displaying the records that are expected.

Right now when someone wants to open the sub level, they click on the plus
sign on a record on the main form. Then to open the subsub level, they must
click on the plus sign in the sub level.

What I'd like to do is ... when someone clicks on the a record's plus sign
in the main form the form opens BOTH sub AND subsub forms. Likewise clicking
on the minus sign would close the sub AND subsub forms. It doesn't
necessarily have to be tied to the click on the plus or minus signs (although
that would be logical) ...

I'm just looking for a way to control the expanded/collapsed state of the
sub, subsub, subsubsub, etc forms along with the 1st or main level.

Unfortunately the form's SubdatasheetExpanded property expands/collapses the
datasheets for ALL records not just for the record clicked.