<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2726.2500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><STRONG>Rocky,</STRONG></DIV>
<DIV> </DIV>
<DIV> Blank rectangle in place of subform (on
opening the main form in design view), is indicative of the subform being
already open in design view, even though you might not have consciously opened
the same. </DIV>
<DIV> </DIV>
<DIV> Whenever the code module for any form or report is
handled in the VBA editor, the corresponding object (form / subform / report /
subreport) gets simultaneously opened in design view.</DIV>
<DIV> </DIV>
<DIV> Remedy - Close the main form, open the subform in design
view (no need to keep searching for it), close it - and then open the main form
in design view. Everything should be OK.</DIV>
<DIV> </DIV>
<DIV> Prevention - Prior to undertaking any editing
of associated code modules of the main or subform, open the main form in design
view. This will forestall the problem mentioned by you.</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><STRONG>A.D.Tejpal</STRONG></DIV>
<DIV><STRONG>--------------</STRONG></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=bchacc@san.rr.com href="mailto:bchacc@san.rr.com">Rocky Smolin -
Beach Access Software</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, September 17, 2003
21:27</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] SubForm Disappears
In Design View</DIV>
<DIV><BR></DIV>I always (try to remember to) turn off the Autocorrect
feature. It causes<BR>some problem that I can't remember anymore, only
that I want that sucker off<BR>all the time.<BR><BR>So if I turn it on maybe
the disappearing sub-forms will stop disappearing<BR>(but I'll get that other
problem back)?<BR><BR>Regards,<BR><BR>Rocky<BR><BR>----- Original Message
----- <BR>From: "Michael R Mattys" <<A
href="mailto:michael.mattys@adelphia.net">michael.mattys@adelphia.net</A>><BR>To:
"Access Developers discussion and problem solving"<BR><<A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>><BR>Sent:
Wednesday, September 17, 2003 8:37 AM<BR>Subject: Re: [AccessD] SubForm
Disappears In Design View<BR><BR><BR>> Rocky,<BR>><BR>> After looking
over TSI_Subforminator, I have<BR>> come to the conclusion that it has to
do with the<BR>> Name AutoCorrect feature.<BR>><BR>> Apparently, it
needs to open subforms live in order<BR>> to track the names.
TSI_Subforminator appears to<BR>> update the name maps for the Access 2000
Name<BR>> AutoCorrect feature before opening a subform in<BR>> design
view.<BR>><BR>> Michael R. Mattys<BR>> Try MattysMapLib for MapPoint
at<BR>> <A
href="http://www.mattysconsulting.com">www.mattysconsulting.com</A><BR>><BR>><BR>><BR>>
----- Original Message -----<BR>> From: "Rocky Smolin - Beach Access
Software" <<A
href="mailto:bchacc@san.rr.com">bchacc@san.rr.com</A>><BR>> To: "Access
Developers discussion and problem solving"<BR>> <<A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>><BR>>
Sent: Wednesday, September 17, 2003 9:41 AM<BR>> Subject: Re: [AccessD]
SubForm Disappears In Design View<BR>><BR>><BR>> >
Michael:<BR>> ><BR>> > Well that works around the problem when it
occurs. Thanks. I'm still<BR>> > curious about why that
happens. There doesn't seem to be any pattern to<BR>> it.<BR>>
><BR>> > Best,<BR>> ><BR>> > Rocky<BR>> ><BR>>
> ----- Original Message -----<BR>> > From: "Michael R Mattys" <<A
href="mailto:michael.mattys@adelphia.net">michael.mattys@adelphia.net</A>><BR>>
> To: "Access Developers discussion and problem solving"<BR>> >
<<A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>><BR>>
> Sent: Tuesday, September 16, 2003 9:45 PM<BR>> > Subject: Re:
[AccessD] SubForm Disappears In Design View<BR>> ><BR>> ><BR>>
> > Hello Rocky,<BR>> > ><BR>> > > Michael Kaplan made
something for this<BR>> > > Look here:<BR>> > > <A
href="http://www.trigeminal.com/lang/1033/utility.asp?ItemID=5">http://www.trigeminal.com/lang/1033/utility.asp?ItemID=5</A><BR>>
> ><BR>> > > Michael R. Mattys<BR>> > > Try
MattysMapLib for MapPoint at<BR>> > > <A
href="http://www.mattysconsulting.com">www.mattysconsulting.com</A><BR>>
> ><BR>> > ><BR>> > ><BR>> > > ----- Original
Message -----<BR>> > > From: "Rocky Smolin - Beach Access Software"
<<A href="mailto:bchacc@san.rr.com">bchacc@san.rr.com</A>><BR>> >
> To: <<A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A>><BR>>
> > Sent: Wednesday, September 17, 2003 12:29 AM<BR>> > >
Subject: [AccessD] SubForm Disappears In Design View<BR>> > ><BR>>
> ><BR>> > > Dear List:<BR>> > ><BR>> > > In
A2K sometimes when I open a main form with a subform in
design<BR>view,<BR>> my<BR>> > > sub-form disappears to be
replaced by a big white box. If I want to<BR>> work<BR>> >
on<BR>> > > it, I have to close the main form and open the subform in
design view<BR>> from<BR>> > > the database container. Then,
some random amount of time later, the<BR>> > subform<BR>> > >
reappears on the main form in design view. It's a real PITA.<BR>> >
><BR>> > > Has anyone seen this behavior and found a solution to
it?<BR>> > ><BR>> > > MTIA,<BR>> > ><BR>> >
> is<BR></BLOCKQUOTE></BODY></HTML>