NZ #ERROR Working

To everyone that helped. Thank you!
I got it to work, How though makes no sense. I moved the Calculated
Textbox off the Subform and onto the Main form and refernced back to a
control that doesn't exsist on the first Subform..

=IIf(IsNull(Forms!Orders.[Order Details]![Mod Price]),0,DSum("[Mod
Price]","Mods Detail Query","[Order ID] = " & [Order ID]))


Mod Price doesn't exsist on the Order Details form, so how this is
working I don't know! But it is.
Thank You
All
Again
DS

I'm glad it's working but if the calculated textbox is now on the Main form
this should work:

=nz(DSum("[Mod Price]","Mods Detail Query","[Order ID] = " & [Order ID]),0)

I'm surprised you're not getting an error trying to reference something that
doesn't exist.


"DS" wrote in message
...
| To everyone that helped. Thank you!
| I got it to work, How though makes no sense. I moved the Calculated
| Textbox off the Subform and onto the Main form and refernced back to a
| control that doesn't exsist on the first Subform..
|
| =IIf(IsNull(Forms!Orders.[Order Details]![Mod Price]),0,DSum("[Mod
| Price]","Mods Detail Query","[Order ID] = " & [Order ID]))
|
|
| Mod Price doesn't exsist on the Order Details form, so how this is
| working I don't know! But it is.
| Thank You
| All
| Again
| DS

DebbieG wrote:

I'm glad it's working but if the calculated textbox is now on the Main form
this should work:

=nz(DSum("[Mod Price]","Mods Detail Query","[Order ID] = " & [Order ID]),0)

I'm surprised you're not getting an error trying to reference something that
doesn't exist.


"DS" wrote in message
...
| To everyone that helped. Thank you!
| I got it to work, How though makes no sense. I moved the Calculated
| Textbox off the Subform and onto the Main form and refernced back to a
| control that doesn't exsist on the first Subform..
|
| =IIf(IsNull(Forms!Orders.[Order Details]![Mod Price]),0,DSum("[Mod
| Price]","Mods Detail Query","[Order ID] = " & [Order ID]))
|
|
| Mod Price doesn't exsist on the Order Details form, so how this is
| working I don't know! But it is.
| Thank You
| All
| Again
| DS

Just tried your code..doesn't work. This weird that something that
makes no sense works, and something that does doesn't!
Thanks
DS