Expand/Collaspe feature in Access2007

  • Thread starter Thread starter KADL
  • Start date Start date
K

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!
 
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.
 
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.
 
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!
Click to expand...

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.
 
Thanks, John. My users like it, but you I'll do the extra subform instead
and explain to them why it is necessary.
 
Back
Top