[AccessD] Error 2448 "You can not assign a value to thisobject."

Thank John,

My original code used me.txtFee, got the same error.  Also tried in the
Activate event, same error.  The load event is supposed to have all the form
data populated so I would think setting a text box value would not create a
problem.  Seems like I do this all the time.

I did not mention in the orginal post that there is a subform on the problem
form, but it has nothing to do with the text box I am trying to update.

Thanks again.

Doug 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Skolits
Sent: Tuesday, August 01, 2006 8:44 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Error 2448 "You can not assign a value to
thisobject."

1)Just a guess but try dropping the ".value" part of the expression.

2)At times I used the ! symbol instead of the "."  
Example:  Me!txtFee = Nz(DSum...

3) Also try placing it in the onOpen event, or oncurrent event.

Maybe one of these will help.

John


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Tuesday, August 01, 2006 11:06 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Error 2448 "You can not assign a value to this object."

Folks,

I am frustrated because a form has started throwing an error and I can not
seem to isolate it. This was working last week, I think, and now I get the
error.  It is probably something very simple I am not seeing.  IN the onLoad
event of the form I have a statement 

Me.txtFee.Value = Nz(DSum("ShowAmount", "qryVendorWeddingFee"), 0) +
Nz(DSum("TotalTax", "qryVendorWeddingFee"), 0)

When the form opens I get the subject error message. For debugging purposes
I commmented the line out and put a button on the form that does the same
thing.  This works fine setting me.txtFee to the proper value.  At first I
was using me.txtFee =, and got the same error.

Do any of you see what is going on here?

Thanks in advance.

Doug

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com