<!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.2800.1126" name=GENERATOR></HEAD>
<BODY style="COLOR: #000000; FONT-FAMILY: Arial">
<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></BODY></HTML>