Expand/Collaspe feature in Access2007

[KADL]

What causes the expand + to appear on a form or subform? I created a routine
form with a table subform using one of the wizards. Through no no effort on
my part, the subform rows had the + to drill down to related records and I
was pleased to have that.

After adding some more tables and updating the relationships in my database,
the Expand + is no longer visible on that subform's data rows.

I don't know how that happened or how to get that feature back. It never
happened again when I created additional forms for other data from related
tables.

Help! Thanks!

 

[KADL]

I should have also said that when I open the table itself, the expand + is
there, so that tells me I didn't mess up the relationships.

Thanks.

 

[KADL]

Uh-Oh! The other thing I did in the interim was to separate the front and
back ends and link the tables. When I open the table in the backend, the
expand + is there but when I open the table in the front-end it is NOT there.
I compared the relationship window in both and they are identical.

Tanks for your help.

 

[John W. Vinson]

What causes the expand + to appear on a form or subform? I created a routine
form with a table subform using one of the wizards. Through no no effort on
my part, the subform rows had the + to drill down to related records and I
was pleased to have that.

After adding some more tables and updating the relationships in my database,
the Expand + is no longer visible on that subform's data rows.

I don't know how that happened or how to get that feature back. It never
happened again when I created additional forms for other data from related
tables.

Help! Thanks!

This (mis)feature is called a Subdatasheet. It's a terrible drag on
performance; it's confusing; it's hard to control; and it's unnecessary, since
you can duplicate its functionality with another subform.

And yes, it's not available in linked tables.

 

[KADL]

Thanks, John. My users like it, but you I'll do the extra subform instead
and explain to them why it is necessary.