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