Coutts, Welford L.
COUTTSW at rjrt.com
Thu Sep 25 13:53:11 CDT 2003
The code is run in the comboBox AfterUpdate event.
It is on a main form, not a subform.
Welford
-----Original Message-----
From: Andy Lacey [mailto:andy at minstersystems.co.uk]
Sent: Thursday, September 25, 2003 1:24 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] SAVING DATA ON FORM
What event is the code in? And is the code run on the main fom itself or a subform, or what?
Andy Lacey
http://www.minstersystems.co.uk <http://www.minstersystems.co.uk/>
-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Coutts, Welford L.
Sent: 25 September 2003 17:26
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] SAVING DATA ON FORM
Andy,
Tried it :
Forms!frmMain.Form!txtID = strID
Same results.
Thanks,
Welford
-----Original Message-----
From: Andy Lacey [mailto:andy at minstersystems.co.uk]
Sent: Thursday, September 25, 2003 12:10 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] SAVING DATA ON FORM
Welford
Just a possibility. try changing the line to:
Forms!frmMain.Form!txtID = strID
--
Andy Lacey
http://www.minstersystems.co.uk
--------- Original Message --------
From: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Subject: RE: [AccessD] SAVING DATA ON FORM
Date: 25/09/03 15:56
Charlotte,
Yes I used a breakpoint. In the code :
Dim strID As String
strID = "*"
Forms!frmMain!txtID = strID
the system halts and gives me the message when it tries to execute :
Forms!frmMain!txtID = strID
Any ideas will be appreciated!
Welford
-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
Sent: Thursday, September 25, 2003 11:21 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] SAVING DATA ON FORM
Where exactly are you getting the message, in the main form or the other
forms or reports? Have you put a breakpoint into code to find the
exact line that is triggering the message? Are you referencing the
hidden control in code, in a query, or what?
Charlotte Foust
-----Original Message-----
From: Coutts, Welford L. [mailto:COUTTSW at rjrt.com]
Sent: Thursday, September 25, 2003 4:37 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] SAVING DATA ON FORM
I have a Main form from which I call numerous other forms and reports. I
have a number of hidden text boxes on this form which I use to pass data
between other forms and to reports. I have done this in dozens of
applications. But this week
it won't work! I get : "Run-time error '438' Object doesn't support
this property or method"
I am using Access 2000 with all the latest revs applied. I have tried
all kinds of changes to try to get around this error, including using a
class module to save on the main form instead of saving from another
form, and including any additional References that seemed to be related
in any way. Nothing helped.
If someone could tell me what I have missed, I would appreciate it.
Welford Coutts
_____
CONFIDENTIALITY NOTE: This e-mail message, including any attachment(s),
contains information that may be confidential, protected by the
attorney-client or other legal privileges, and/or proprietary non-public
information. If you are not an intended recipient of this message or an
authorized assistant to an intended recipient, please notify the sender
by replying to this message and then delete it from your system. Use,
dissemination, distribution, or reproduction of this message and/or any
of its attachments (if
any) by unintended recipients is not authorized and may be unlawful.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/>
-----------------------------------------
CONFIDENTIALITY NOTE: This e-mail message, including any
attachment(s), contains information that may be confidential,
protected by the attorney-client or other legal privileges, and/or
proprietary non-public information. If you are not an intended
recipient of this message or an authorized assistant to an intended
recipient, please notify the sender by replying to this message and
then delete it from your system. Use, dissemination, distribution,
or reproduction of this message and/or any of its attachments (if
any) by unintended recipients is not authorized and may be unlawful.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/>
________________________________________________
Message sent using UebiMiau 2.7.2
_____
CONFIDENTIALITY NOTE: This e-mail message, including any
attachment(s), contains information that may be confidential,
protected by the attorney-client or other legal privileges, and/or
proprietary non-public information. If you are not an intended
recipient of this message or an authorized assistant to an intended
recipient, please notify the sender by replying to this message and
then delete it from your system. Use, dissemination, distribution,
or reproduction of this message and/or any of its attachments (if
any) by unintended recipients is not authorized and may be unlawful.
-----------------------------------------
CONFIDENTIALITY NOTE: This e-mail message, including any
attachment(s), contains information that may be confidential,
protected by the attorney-client or other legal privileges, and/or
proprietary non-public information. If you are not an intended
recipient of this message or an authorized assistant to an intended
recipient, please notify the sender by replying to this message and
then delete it from your system. Use, dissemination, distribution,
or reproduction of this message and/or any of its attachments (if
any) by unintended recipients is not authorized and may be unlawful.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030925/9333d597/attachment-0001.html>