By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,821 Members | 1,092 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,821 IT Pros & Developers. It's quick & easy.

Odd behavior in A2K Form! Help!

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
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?

Nov 12 '05 #2

P: n/a
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.


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.