<!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.2722.900" name=GENERATOR></HEAD>
<BODY style="COLOR: #000000; FONT-FAMILY: Arial">
<DIV><SPAN class=608102715-25092003><FONT size=2>No "IF" statements; both
the Main and the called forms are unbound.</FONT></SPAN></DIV>
<DIV><SPAN class=608102715-25092003>The Main form primarily has a number of
command buttons for the user</SPAN></DIV>
<DIV><SPAN class=608102715-25092003>to select where they want to go
next.</SPAN></DIV>
<DIV><SPAN class=608102715-25092003>The called form has a combo box that lists
the states from a table.</SPAN></DIV>
<DIV><SPAN class=608102715-25092003></SPAN> </DIV>
<DIV><SPAN class=608102715-25092003><FONT size=2>The controls are hidden because
there are a large number of them and</FONT></SPAN></DIV>
<DIV><SPAN class=608102715-25092003>they would make the form very cluttered for
the user and would display a lot</SPAN></DIV>
<DIV><SPAN class=608102715-25092003>of data that are of no use to the
user.</SPAN></DIV>
<DIV><SPAN class=608102715-25092003></SPAN> </DIV>
<DIV><SPAN class=608102715-25092003><FONT size=2>Welford</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Jim Hewson
[mailto:JHewson@karta.com]<BR><B>Sent:</B> Thursday, September 25, 2003 11:01
AM<BR><B>To:</B> 'Access Developers discussion and problem
solving'<BR><B>Subject:</B> RE: [AccessD] SAVING DATA ON
FORM<BR><BR></FONT></DIV>
<DIV><SPAN class=625035214-25092003><FONT size=2>Do you have an "IF" statement
in the opening form/report's query criteria? If so, is it working
correctly?</FONT></SPAN></DIV>
<DIV><SPAN class=625035214-25092003><FONT size=2>Just out of curiosity, why do
you have hidden controls on the main form?</FONT> </SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Coutts, Welford L.
[mailto:COUTTSW@rjrt.com]<BR><B>Sent:</B> Thursday, September 25, 2003 9:38
AM<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> RE: [AccessD] SAVING DATA ON
FORM<BR><BR></FONT></DIV>
<DIV><SPAN class=483422114-25092003><FONT size=2>Jim,</FONT></SPAN></DIV>
<DIV><SPAN class=483422114-25092003><FONT size=2>txtID is going to be a
state abbreviation after the user makes a selection, like NC, FL, MA,
etc.</FONT></SPAN></DIV>
<DIV><SPAN class=483422114-25092003>As a default, I am trying to
put * in it until the user makes his choice.</SPAN></DIV>
<DIV><SPAN class=483422114-25092003></SPAN> </DIV>
<DIV><SPAN class=483422114-25092003><FONT size=2>I tried changing
strID to Integer, as you suggested, and set it equal to 2.
It worked fine up until</FONT></SPAN></DIV>
<DIV><SPAN class=483422114-25092003>the "
Forms!frmMain!txtID = strID " statement, when
it failed as before. </SPAN></DIV>
<DIV><SPAN class=483422114-25092003></SPAN> </DIV>
<DIV><SPAN class=483422114-25092003><FONT size=2>And don't stop giving me
things to try, I've exhausted my list!</FONT></SPAN></DIV>
<DIV><SPAN class=483422114-25092003></SPAN> </DIV>
<DIV><SPAN class=483422114-25092003><FONT size=2>TIA</FONT></SPAN></DIV>
<DIV><SPAN class=483422114-25092003>Welford</SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Jim Hewson
[mailto:JHewson@karta.com]<BR><B>Sent:</B> Thursday, September 25, 2003
9:42 AM<BR><B>To:</B> 'Access Developers discussion and problem
solving'<BR><B>Subject:</B> RE: [AccessD] SAVING DATA ON
FORM<BR><BR></FONT></DIV>
<DIV><SPAN class=609372013-25092003><FONT size=2>What data is txtID
matched with?</FONT></SPAN></DIV>
<DIV><SPAN class=609372013-25092003><FONT size=2>Yep, same problem I
had. The form I was opening, couldn't use the
data.</FONT></SPAN></DIV>
<DIV><SPAN class=609372013-25092003><FONT size=2>The control was text, I
was feeding it text, the form I was opening was using
numeric.</FONT></SPAN></DIV>
<DIV><SPAN class=609372013-25092003><FONT size=2>Two other
thoughts.</FONT></SPAN></DIV>
<DIV><SPAN class=609372013-25092003><FONT size=2>1. Check the object
of the form/report your opening. Check its data
type.</FONT></SPAN></DIV>
<DIV><SPAN class=609372013-25092003><FONT size=2>2. As a test --
change As String to As Integer and see what happens.</FONT></SPAN></DIV>
<DIV><SPAN class=609372013-25092003><FONT
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609372013-25092003><FONT size=2>I know, I sound like a
broken record... but I spent way too much time (hours) running through a
similar problem.</FONT></SPAN></DIV>
<DIV><SPAN class=609372013-25092003><FONT
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609372013-25092003><FONT size=2>I'll keep quiet
now.</FONT></SPAN></DIV>
<DIV><SPAN class=609372013-25092003><FONT
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609372013-25092003><FONT size=2>Jim</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Coutts, Welford L.
[mailto:COUTTSW@rjrt.com]<BR><B>Sent:</B> Thursday, September 25, 2003
8:16 AM<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> RE: [AccessD] SAVING DATA ON
FORM<BR><BR></FONT></DIV>
<DIV><SPAN class=998141013-25092003><FONT
size=2>Jim,</FONT></SPAN></DIV>
<DIV><SPAN class=998141013-25092003>Thanks for taking time to
reply. However, they are text boxes.</SPAN></DIV>
<DIV><SPAN class=998141013-25092003>For testing, I have pared the code
down to this :</SPAN></DIV>
<DIV><SPAN class=998141013-25092003> </SPAN></DIV>
<DIV><SPAN class=998141013-25092003> Dim
strID As String</SPAN></DIV>
<DIV><SPAN class=998141013-25092003> strID =
"*"</SPAN></DIV>
<DIV><SPAN class=998141013-25092003>
Forms!frmMain!txtID = strID</SPAN></DIV>
<DIV><SPAN class=998141013-25092003></SPAN> </DIV>
<DIV><SPAN class=998141013-25092003><FONT size=2>which fails as I
described.</FONT></SPAN></DIV>
<DIV><SPAN class=998141013-25092003>Any other ideas?</SPAN></DIV>
<DIV><SPAN class=998141013-25092003></SPAN> </DIV>
<DIV><SPAN class=998141013-25092003><FONT
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=998141013-25092003>Welford</SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Jim Hewson
[mailto:JHewson@karta.com]<BR><B>Sent:</B> Thursday, September 25,
2003 8:54 AM<BR><B>To:</B> 'Access Developers discussion and problem
solving'<BR><B>Subject:</B> RE: [AccessD] SAVING DATA ON
FORM<BR><BR></FONT></DIV>
<DIV><SPAN class=406095112-25092003><FONT size=2>Check the data type
for your "hidden text boxes."</FONT></SPAN></DIV>
<DIV><SPAN class=406095112-25092003><FONT size=2>I spent a lot of time
tracking down the same thing recently. I was trying to pass a
text value to the query, when in fact it was
numeric!</FONT></SPAN></DIV>
<DIV><SPAN class=406095112-25092003><FONT
size=2>HTH</FONT></SPAN></DIV>
<DIV><SPAN class=406095112-25092003><FONT
size=2>Jim</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Coutts, Welford L.
[mailto:COUTTSW@rjrt.com]<BR><B>Sent:</B> Thursday, September 25,
2003 7:37 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD] SAVING
DATA ON FORM<BR><BR></FONT></DIV>
<DIV><SPAN class=748391812-25092003>I have a Main form from which I
call numerous other forms and reports.</SPAN></DIV>
<DIV><SPAN class=748391812-25092003>I have a number of hidden text
boxes on this form which I use to pass data between</SPAN></DIV>
<DIV><SPAN class=748391812-25092003>other forms and to
reports. I have done this in dozens of applications. But
this week</SPAN></DIV>
<DIV><SPAN class=748391812-25092003>it won't work! I get
: "Run-time error '438' Object doesn't
support this property or method"</SPAN></DIV>
<DIV><SPAN class=748391812-25092003></SPAN> </DIV>
<DIV><SPAN class=748391812-25092003>I am using Access 2000 with all
the latest revs applied. I have tried all kinds of changes
to</SPAN></DIV>
<DIV><SPAN class=748391812-25092003>try to get around this error,
including using a class module to save on the main form
instead</SPAN></DIV>
<DIV><SPAN class=748391812-25092003>of saving from another form, and
including any additional References that seemed to be</SPAN></DIV>
<DIV><SPAN class=748391812-25092003>related in any way.
Nothing helped.</SPAN></DIV>
<DIV><SPAN class=748391812-25092003></SPAN> </DIV>
<DIV><SPAN class=748391812-25092003>If someone could tell me what I
have missed, I would appreciate it.</SPAN></DIV>
<DIV><SPAN class=748391812-25092003></SPAN> </DIV>
<DIV><SPAN class=748391812-25092003></SPAN> </DIV>
<DIV><STRONG><EM><FONT color=#800000>Welford<SPAN
class=748391812-25092003> Coutts</SPAN></FONT></EM></STRONG></DIV>
<DIV> </DIV>
<P>
<HR SIZE=1>
<P></P>
<P><STRONG>CONFIDENTIALITY NOTE: This e-mail message, including
any<BR>attachment(s), contains information that may be
confidential,<BR>protected by the attorney-client or other legal
privileges, and/or<BR>proprietary non-public information. If you are
not an intended<BR>recipient of this message or an authorized
assistant to an intended<BR>recipient, please notify the sender by
replying to this message and<BR>then delete it from your system.
Use, dissemination, distribution,<BR>or reproduction of this message
and/or any of its attachments (if<BR>any) by unintended recipients
is not authorized and may be
unlawful.</STRONG></P></BLOCKQUOTE></BLOCKQUOTE>
<P>
<HR SIZE=1>
<P></P>
<P><STRONG>CONFIDENTIALITY NOTE: This e-mail message, including
any<BR>attachment(s), contains information that may be
confidential,<BR>protected by the attorney-client or other legal
privileges, and/or<BR>proprietary non-public information. If you are not
an intended<BR>recipient of this message or an authorized assistant to
an intended<BR>recipient, please notify the sender by replying to this
message and<BR>then delete it from your system. Use, dissemination,
distribution,<BR>or reproduction of this message and/or any of its
attachments (if<BR>any) by unintended recipients is not authorized and
may be unlawful.</STRONG></P></BLOCKQUOTE></BLOCKQUOTE>
<P>
<HR SIZE=1>
<P></P>
<P><STRONG>CONFIDENTIALITY NOTE: This e-mail message, including
any<BR>attachment(s), contains information that may be
confidential,<BR>protected by the attorney-client or other legal privileges,
and/or<BR>proprietary non-public information. If you are not an
intended<BR>recipient of this message or an authorized assistant to an
intended<BR>recipient, please notify the sender by replying to this message
and<BR>then delete it from your system. Use, dissemination,
distribution,<BR>or reproduction of this message and/or any of its
attachments (if<BR>any) by unintended recipients is not authorized and may
be unlawful.</STRONG></P></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
<HTML><BODY><P><hr size=1></P><P><STRONG>CONFIDENTIALITY NOTE: This e-mail message, including any<br>attachment(s), contains information that may be confidential,<br>protected by the attorney-client or other legal privileges, and/or<br>proprietary non-public information. If you are not an intended<br>recipient of this message or an authorized assistant to an intended<br>recipient, please notify the sender by replying to this message and<br>then delete it from your system. Use, dissemination, distribution,<br>or reproduction of this message and/or any of its attachments (if<br>any) by unintended recipients is not authorized and may be unlawful.</STRONG></P></BODY></HTML>