sub form & sub-subform drill down question

ok so i have a form that has a subform and that subform has a subform, so 3
layers of forms.

the sub form & sub-subform are both datasheets, so when i click the + sign
on the subform the sub-subform expands, similar to a drill down function.

both the form and the sub form have checkboxes on them.

the idea is you can select the whole group of records or your can drill down
and selet individual records from the group.

i know i can manually get the data to do what i want with recordsets and
loops. but i was wondering if someone had a more elegant solution.

the subform cannot bebound to the main form, but the sub-subform can be
bound to the subform

Hi,
if your main goal is to make a selection with checkboxes - then consider
using treeview control
http://www.pointltd.com/Downloads/Details.asp?dlID=36

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


"Joseph Atie" <JosephAtie@discussions.microsoft.com> wrote in message
news:FF76229F-8303-4827-9532-FFA71BCE56F9@microsoft.com...
> ok so i have a form that has a subform and that subform has a subform, so
> 3
> layers of forms.
>
> the sub form & sub-subform are both datasheets, so when i click the + sign
> on the subform the sub-subform expands, similar to a drill down function.
>
> both the form and the sub form have checkboxes on them.
>
> the idea is you can select the whole group of records or your can drill
> down
> and selet individual records from the group.
>
> i know i can manually get the data to do what i want with recordsets and
> loops. but i was wondering if someone had a more elegant solution.
>
> the subform cannot bebound to the main form, but the sub-subform can be
> bound to the subform

can this be used for multiple selection? the example you give only has single
selection

"Alex Dybenko" wrote:

> Hi,
> if your main goal is to make a selection with checkboxes - then consider
> using treeview control
> http://www.pointltd.com/Downloads/Details.asp?dlID=36
>
> --
> Best regards,
> ___________
> Alex Dybenko (MVP)
> http://accessblog.net
> http://www.PointLtd.com
>
>
> "Joseph Atie" <JosephAtie@discussions.microsoft.com> wrote in message
> news:FF76229F-8303-4827-9532-FFA71BCE56F9@microsoft.com...
> > ok so i have a form that has a subform and that subform has a subform, so
> > 3
> > layers of forms.
> >
> > the sub form & sub-subform are both datasheets, so when i click the + sign
> > on the subform the sub-subform expands, similar to a drill down function.
> >
> > both the form and the sub form have checkboxes on them.
> >
> > the idea is you can select the whole group of records or your can drill
> > down
> > and selet individual records from the group.
> >
> > i know i can manually get the data to do what i want with recordsets and
> > loops. but i was wondering if someone had a more elegant solution.
> >
> > the subform cannot bebound to the main form, but the sub-subform can be
> > bound to the subform
>
>

Hi,
yes, you can enable checkboxes (property of treeview control) and the select
using them

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


"Joseph Atie" <JosephAtie@discussions.microsoft.com> wrote in message
news:61E992F8-73F5-4039-90DE-988EFBED9F1E@microsoft.com...
> can this be used for multiple selection? the example you give only has
> single
> selection
>
> "Alex Dybenko" wrote:
>
>> Hi,
>> if your main goal is to make a selection with checkboxes - then consider
>> using treeview control
>> http://www.pointltd.com/Downloads/Details.asp?dlID=36
>>
>> --
>> Best regards,
>> ___________
>> Alex Dybenko (MVP)
>> http://accessblog.net
>> http://www.PointLtd.com
>>
>>
>> "Joseph Atie" <JosephAtie@discussions.microsoft.com> wrote in message
>> news:FF76229F-8303-4827-9532-FFA71BCE56F9@microsoft.com...
>> > ok so i have a form that has a subform and that subform has a subform,
>> > so
>> > 3
>> > layers of forms.
>> >
>> > the sub form & sub-subform are both datasheets, so when i click the +
>> > sign
>> > on the subform the sub-subform expands, similar to a drill down
>> > function.
>> >
>> > both the form and the sub form have checkboxes on them.
>> >
>> > the idea is you can select the whole group of records or your can drill
>> > down
>> > and selet individual records from the group.
>> >
>> > i know i can manually get the data to do what i want with recordsets
>> > and
>> > loops. but i was wondering if someone had a more elegant solution.
>> >
>> > the subform cannot bebound to the main form, but the sub-subform can
>> > be
>> > bound to the subform
>>
>>