<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=167214611-26092003><FONT color=#0000ff size=2>Andy, It
executes correctly from the immediate window in frmSelect ( the one
called</FONT></SPAN></DIV>
<DIV><SPAN class=167214611-26092003><FONT color=#0000ff size=2>from frmMain
)! It places * in the txtID field on </FONT></SPAN><SPAN
class=167214611-26092003><FONT color=#0000ff>frmMain correctly! So why
will the same </FONT></SPAN></DIV>
<DIV><SPAN class=167214611-26092003><FONT color=#0000ff>code not execute from
frmSelect's vb code?</FONT></SPAN></DIV>
<DIV><SPAN class=167214611-26092003><FONT color=#0000ff>Instead I get
"Object doesn't support this property or method"</FONT></SPAN></DIV>
<DIV><SPAN class=167214611-26092003><FONT
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=167214611-26092003><FONT
color=#0000ff>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=167214611-26092003><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> Friday, September 26, 2003
2:57 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=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></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>