<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1226" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=649575406-26092003><FONT size=2><FONT face=Arial>If you set a
break at that point and express Forms!frmMain!txtID in the immediate window,
what do you get?</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=649575406-26092003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=649575406-26092003><FONT face=Arial
size=2>Andy</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Coutts,
Welford L.<BR><B>Sent:</B> 25 September 2003 19:53<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=248294717-25092003><FONT color=#0000ff size=2>The code is run
in the comboBox AfterUpdate event.</FONT></SPAN></DIV>
<DIV><SPAN class=248294717-25092003><FONT color=#0000ff>It is on a main form,
not a subform. </FONT></SPAN></DIV>
<DIV><SPAN class=248294717-25092003><FONT
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=248294717-25092003><FONT
color=#0000ff>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> Andy Lacey
[mailto:andy@minstersystems.co.uk]<BR><B>Sent:</B> Thursday, September 25,
2003 1:24 PM<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=336392217-25092003><FONT face=Arial color=#0000ff
size=2>What event is the code in? And is the code run on the main fom
itself or a subform, or what?</FONT></SPAN></DIV>
<DIV><SPAN class=336392217-25092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=336392217-25092003><!-- Converted from text/plain format -->
<P><FONT size=2>Andy Lacey<BR><A
href="http://www.minstersystems.co.uk/">http://www.minstersystems.co.uk</A>
</FONT></P></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Coutts,
Welford L.<BR><B>Sent:</B> 25 September 2003 17:26<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><FONT color=#0000ff><SPAN
class=764412416-25092003>Andy,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff><SPAN class=764412416-25092003>Tried it
:</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff><SPAN class=764412416-25092003>
<FONT face="Courier New" color=#000000>Forms!frmMain.Form!txtID =
strID</FONT><BR><BR>Same results.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff><SPAN
class=764412416-25092003>Thanks,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff><SPAN
class=764412416-25092003>Welford</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff><SPAN
class=764412416-25092003></SPAN></FONT> </DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT
face=Tahoma>-----Original Message-----<BR><B>From:</B> Andy Lacey
[mailto:andy@minstersystems.co.uk]<BR><B>Sent:</B> Thursday, September
25, 2003 12:10 PM<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> RE: [AccessD] SAVING DATA ON
FORM<BR><BR></FONT></DIV>Welford<BR>Just a possibility. try changing the
line to:<BR><BR><FONT face="Courier New">Forms!frmMain.Form!txtID =
strID</FONT><BR><BR>--<BR>Andy
Lacey<BR>http://www.minstersystems.co.uk<BR><BR><BR><BR>
<BLOCKQUOTE dir=ltr
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
--------<BR>From: "Access Developers discussion and problem solving"
<accessd@databaseadvisors.com><BR>To: "Access Developers
discussion and problem solving"
<accessd@databaseadvisors.com><BR>Subject: RE: [AccessD] SAVING
DATA ON FORM<BR>Date: 25/09/03 15:56<BR><BR><FONT
face="Courier New"><BR>Charlotte,<BR>Yes I used a breakpoint. In the
code :<BR><BR>Dim strID As String<BR>strID =
"*"<BR>Forms!frmMain!txtID = strID<BR><BR>the system halts and gives
me the message when it tries to execute :<BR>Forms!frmMain!txtID =
strID<BR><BR>Any ideas will be
appreciated!<BR><BR>Welford<BR><BR>-----Original Message-----<BR>From:
Charlotte Foust [mailto:cfoust@infostatsystems.com]<BR>Sent: Thursday,
September 25, 2003 11:21 AM<BR>To: Access Developers discussion and
problem solving<BR>Subject: RE: [AccessD] SAVING DATA ON
FORM<BR><BR><BR>Where exactly are you getting the message, in the main
form or the other<BR>forms or reports? Have you put a breakpoint into
code to find the<BR>exact line that is triggering the message? Are you
referencing the<BR>hidden control in code, in a query, or
what?<BR><BR>Charlotte Foust<BR><BR>-----Original
Message-----<BR>From: Coutts, Welford L.
[mailto:COUTTSW@rjrt.com]<BR>Sent: Thursday, September 25, 2003 4:37
AM<BR>To: <A class=autolink
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A><BR>Subject:
[AccessD] SAVING DATA ON FORM<BR><BR><BR>I have a Main form from which
I call numerous other forms and reports. I<BR>have a number of hidden
text boxes on this form which I use to pass data<BR>between other
forms and to reports. I have done this in dozens of<BR>applications.
But this week<BR>it won't work! I get : "Run-time error '438' Object
doesn't support<BR>this property or method"<BR><BR>I am using Access
2000 with all the latest revs applied. I have tried<BR>all kinds of
changes to try to get around this error, including using a<BR>class
module to save on the main form instead of saving from
another<BR>form, and including any additional References that seemed
to be related<BR>in any way. Nothing helped.<BR><BR>If someone could
tell me what I have missed, I would appreciate it.<BR><BR><BR>Welford
Coutts<BR><BR><BR>_____<BR><BR>CONFIDENTIALITY NOTE: This e-mail
message, including any attachment(s),<BR>contains information that may
be confidential, protected by the<BR>attorney-client or other legal
privileges, and/or proprietary non-public<BR>information. If you are
not an intended recipient of this message or an<BR>authorized
assistant to an intended recipient, please notify the sender<BR>by
replying to this message and then delete it from your system.
Use,<BR>dissemination, distribution, or reproduction of this message
and/or any<BR>of its attachments (if<BR>any) by unintended recipients
is not authorized and may be
unlawful.<BR><BR>_______________________________________________<BR>AccessD
mailing list<BR><A class=autolink
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
class=autolink
href="http://databaseadvisors.com/mailman/listinfo/accessd"
target=_blank>http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A class=autolink href="http://www.databaseadvisors.com/"
target=_blank>http://www.databaseadvisors.com</A><BR><BR><BR>-----------------------------------------<BR>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.<BR><BR>_______________________________________________<BR>AccessD
mailing list<BR><A class=autolink
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
class=autolink
href="http://databaseadvisors.com/mailman/listinfo/accessd"
target=_blank>http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A class=autolink href="http://www.databaseadvisors.com/"
target=_blank>http://www.databaseadvisors.com</A><BR><BR><BR><BR><BR></FONT></DIV></BLOCKQUOTE><BR><BR>________________________________________________<BR>Message
sent using UebiMiau 2.7.2<BR></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></BODY></HTML>