Run Time Errors

[Stephanie53]

Have Table & Qry in the following:

PrimaryID
Type
Discription
Qty
UnitCost
ExtCost
NetWght
TotalWght

In the Table I put under expressions the following

ExtCost Field: [Qty] * [UnitCost]


TotalWght Field: [Qty] * [NetWght]

Now I am getting this when creating the form:

Run-time error '2147352567(80020009)
you cant assign a value to this object

Ok where am I going wrong when trying to caculate these fields? Do I change the event to say after update for these fields?

[rpeare]

are any of your values null

if they are you likely have to assign a value to account for a null value, for instance:

ExtCost Field: iif(isnull([qty]) or isnull([unitcost]), 0, [Qty] * [UnitCost])

[Stephanie53]

ok here is now what i am getting...



Hope you can see it..

TIA!

[rpeare]

post the formula that is causing the problem in your query. You have an invalid reference to a query, table or form in there somewhere.

[Stephanie53]

ExtCost Field: iif(isnull([qty]) or isnull([unitcost]), 0, [Qty] * [UnitCost])[/QUOTE]

The same exact thing you posted...

[June7]

Is this issue related to https://www.accessforums.net/access/...ess-33614.html ?

Simple arithmetic with null should result in null. If you want to show a 0 instead of null, another method is:

Nz([Qty],0) * Nz([UnitCost],0)

[rpeare]

Remove the calculation field and see if you still get the error. If you do the problem lies elsewhere. If you remove the calculation field and you do still get the error you can do a couple things. Post the entire SQL string or take out one field at a time until the error stops, then look at the field that was causing the problem and post what the contents of that are if you can't figure it out from there.

[Stephanie53]

its been solved!! Yea!! Thanks!!

Stephanie