This is a real teaser Welford. I'd be happy to take a look if you want to
zip it up and email me, but I really can't spot the problem from
here.<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: 26/09/03 12:01<BR><BR>
<META content="MSHTML 6.00.2722.900" name=GENERATOR>
<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>
<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><BR><BR>
<HR>
<BR><FONT face="Courier New"
size=2>_______________________________________________<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></FONT></DIV></BLOCKQUOTE><BR
/>
<BR />
________________________________________________<BR />
Message sent using UebiMiau 2.7.2<BR />