subdatasheet opens automatically

[Slez via AccessMonster.com]

I have one user of a front end database where the following happens:

One particular form (Form1) has a subform (Subform1) in datasheet view, which
has a subdatasheet (Subform2). When Form1 is opened, the subdatasheet,
Subform2 is already expanded.

I can simply redistribute a new copy of the front end to this user and the
problem is fixed, but I am curious what would cause this for my own knowledge.
Any ideas?

Thanks in advance!
Slez

 

[Slez via AccessMonster.com]

Thanks Marshall! The SubdatasheetExpanded property of Subform1 was set to
Yes. This begs me to ask the question. The user had no idea how to get to
design view to change this. Is there a way they could've inadvertantly done
so?...or could Access have changed it on its own?
Thoughts are appreciated!
Slez

I have one user of a front end database where the following happens:

[quoted text clipped - 4 lines]

I can simply redistribute a new copy of the front end to this user and the
problem is fixed, but I am curious what would cause this for my own knowledge.

Check all the SubdatasheetExpanded properties you can find.

 

[Marshall Barton]

I have one user of a front end database where the following happens:

One particular form (Form1) has a subform (Subform1) in datasheet view, which
has a subdatasheet (Subform2). When Form1 is opened, the subdatasheet,
Subform2 is already expanded.

I can simply redistribute a new copy of the front end to this user and the
problem is fixed, but I am curious what would cause this for my own knowledge.

Check all the SubdatasheetExpanded properties you can find.

 

[Marshall Barton]

Excellent question!

The subdatasheet feature is (TBOMK) not popular, certainly
not one I want to get involved with. Therefore, people that
are familiar with it's nuances are few and far between. I
do know that some(?) properties (e.g. Filter) are saved
whether you want it or not, maybe this one is too? Maybe it
happens in conjunction the user filtering or sorting the
form via menu/tool bar actions.

Once upon a time, I had a form become unusable after a user
tried to apply an invalid Filter. In this case I went so
far as to use the form's Close event to reset the property
so if the property were saved, it would be set the way it
was supposed to be.

In your case, I suspect that careful observation of the
troublesome user's actions might shed some light on the
problem.
--
Marsh
MVP [MS Access]

Thanks Marshall! The SubdatasheetExpanded property of Subform1 was set to
Yes. This begs me to ask the question. The user had no idea how to get to
design view to change this. Is there a way they could've inadvertantly done
so?...or could Access have changed it on its own?

I have one user of a front end database where the following happens:

[quoted text clipped - 4 lines]

I can simply redistribute a new copy of the front end to this user and the
problem is fixed, but I am curious what would cause this for my own knowledge.

Check all the SubdatasheetExpanded properties you can find.