If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Expand/Collaspe feature in Access2007
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! |
#2
|
|||
|
|||
Expand/Collaspe feature in Access2007
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" wrote: 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! |
#3
|
|||
|
|||
Expand/Collaspe feature in Access2007
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. "KADL" wrote: 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! |
#4
|
|||
|
|||
Expand/Collaspe feature in Access2007
On Wed, 6 Jan 2010 17:44:01 -0800, KADL
wrote: 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. -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Expand/Collaspe feature in Access2007
Thanks, John. My users like it, but you I'll do the extra subform instead
and explain to them why it is necessary. "John W. Vinson" wrote: On Wed, 6 Jan 2010 17:44:01 -0800, KADL wrote: 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. -- John W. Vinson [MVP] . |
Thread Tools | |
Display Modes | |
|
|