<!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=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></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>