[AccessD] Error 2448 "You can not assign a value tothis object."

The only times I've had this I've resolved it by moving the statement to a
later event, such as the OnFormat of the Report Header.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Gustav Brock
> Sent: 02 August 2006 07:46
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Error 2448 "You can not assign a value 
> tothis object."
> 
> 
> Hi Doug
> 
> If this works:
> 
>   Me!txtFee.Value = 0
> 
> it could have something to do with your query, or you may 
> have an update event of the textbox. Or try without your subform.
> 
> Also, you don't need to call the query twice:
> 
>   Me!txtFee.Value = DSum("Nz(ShowAmount, 0) + Nz(TotalTax, 
> 0)", "qryVendorWeddingFee")
> 
> /gustav
> 
> >>> dw-murphy at cox.net 02-08-2006 05:05:57 >>>
> 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
> 
>