Expansion when viewing tables

[Rob]

Hi all,

I am asking this question to start my research. When I view table data in
MS Access 2003, I am presented with a small cross in the left column that
allows me to expand (based on my relationships) and drill into the data
further.

My question is what is this control called, and can it be replicated in a
form in datasheet view. I have this functioanality at the moment using a
union query (I have attached my query below to help explain the functionality
- this has been modified from one I found for list views however I cannot
remember the author), but I think that I may be able to use this inbuilt
functionality?

Cheers
Rob

 

[Allen Browne]

The little plus sign at the left of a datasheet is called a Subdatasheet.

In table design view, you can define what related table shows data here via
the Subdatasheet Name propety (in the Properties box.)

In form design view, you can set the Subdatasheet Height and
SubdatasheetExpanded properties. However, this works in conjunction with the
Subdatasheet Name from the table, so it may not work as you expect if the
form is bound to a UNION query. You may need to use a subform instead.

In practice, subdatasheets are of limited use (e.g. they lack the events
that a subform has), and they slow the database down (by loading lots of
unnecessary data from additional tables -- particularly noticable with
complex forms with lots of subforms drawing data from attachted tables.) So,
some of us turn them off for all our tables:
http://allenbrowne.com/bug-09.html

 

[Rob]

Thanks Allen. After reading your site I have decided not to use
SubDataSheets and will implement the functionality I want using linked
subforms.

Cheers
Rob

 

[lucienne]

Hi all,

I am asking this question to start my research. When I view table data in
MS Access 2003, I am presented with a small cross in the left column that
allows me to expand (based on my relationships) and drill into the data
further.

My question is what is this control called, and can it be replicated in a
form in datasheet view. I have this functioanality at the moment using a
union query (I have attached my query below to help explain the
functionality
- this has been modified from one I found for list views however I cannot
remember the author), but I think that I may be able to use this inbuilt
functionality?

Cheers
Rob