Odd behavior in A2K Form! Help!

[LaurenW]

Hi Folks,

I have an Access 2K form that includes a normally hidden subform
linked in the normal way. For many months it ran perfectly and it
still does except for one thing -- when we switch to datasheet view,
the subform is expanded and visible for every record even if the
subform was invisible at the moment of the view switch. This just
recently started happening and I am clueless about why.

Anyone have advice on this phenomena?

All responses appreciated.

Thanks.

[Allen Browne]

Changing the view of something that is not visible? Sounds unusual. How are
you doing that? What line of code? It would be interesting to see what is
making it visible. Is the subform control's Visible property altered after
your code runs?

Whatever table the subform is bound to, you could try opening it in deisgn
view and setting its SubdatasheetName property to:
[None]
in the Properties box. That may prevent the "expansion" you mentioned.

"Visible for every record"? Does this mean the subform control is losing its
LinkMasterField/LinkChildField properties? Or does it mean the subform is
losing a filter? There are several bugs associated with filters that can see
a subform displaying all records.

If you don't have Service Pack 3 for Access 2000, it would be worth
downloading it from support.microsoft.com.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"LaurenW" <xx*@xxx.com> wrote in message
news:v3********************************@4ax.com...

I have an Access 2K form that includes a normally hidden subform
linked in the normal way. For many months it ran perfectly and it
still does except for one thing -- when we switch to datasheet view,
the subform is expanded and visible for every record even if the
subform was invisible at the moment of the view switch. This just
recently started happening and I am clueless about why.

Anyone have advice on this phenomena?

[LaurenW]

Allen, thanks very much for your prompt response. I figured out the
problem. During a design session, I accidentally clicked the
"Subdatasheet Expanded" property of the parent form and set it to YES
without realizing it. As soon as I set it back to NO, it started
behaving normally in datasheet view.
On Mon, 29 Dec 2003 10:22:46 +0800, "Allen Browne"
<Al*********@SeeSig.Invalid> wrote:

Changing the view of something that is not visible? Sounds unusual. How are
you doing that? What line of code? It would be interesting to see what is
making it visible. Is the subform control's Visible property altered after
your code runs?

Whatever table the subform is bound to, you could try opening it in deisgn
view and setting its SubdatasheetName property to:
[None]
in the Properties box. That may prevent the "expansion" you mentioned.

"Visible for every record"? Does this mean the subform control is losing its
LinkMasterField/LinkChildField properties? Or does it mean the subform is
losing a filter? There are several bugs associated with filters that can see
a subform displaying all records.

If you don't have Service Pack 3 for Access 2000, it would be worth
downloading it from support.microsoft.com.