subdatasheet opens automatically

  • Thread starter Thread starter Slez via AccessMonster.com
  • Start date Start date
S

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
 
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

Marshall said:
I have one user of a front end database where the following happens:
Click to expand...
[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.
Click to expand...

Check all the SubdatasheetExpanded properties you can find.
Click to expand...
 
Slez said:
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.
Click to expand...


Check all the SubdatasheetExpanded properties you can find.
 
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?


Marshall said:
I have one user of a front end database where the following happens:
Click to expand...
[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.
Click to expand...

Check all the SubdatasheetExpanded properties you can find.
Click to expand...
Click to expand...
 
Back
Top