I have a calculated control on a form which is calculated using this formula:
[Text16] is another calculated control on the form which reflects a calculated sum on a subform on this form. [Text16] is caculated with this formula:
All this works fine except when, as I move thru the records on the Products form, if there are no concommitant records in the subform (the subform is empty), there is no sum on the subform for [Text16] to reflect and and I get an error message. I use the nz function to try to convert null answers for [Text16] to zero, but that doesn't seem to help either.
Does anyone know why this is happening? Thanks for any help.
Robin
Code:
=([TotalItemInventory]-nz([Text16]))+nz(DSum("[numberreturned]","[tblEqptReturn]","[productid] = forms![products]![productid]"))
[Text16] is another calculated control on the form which reflects a calculated sum on a subform on this form. [Text16] is caculated with this formula:
Code:
=nz([frmProductOrders Subform].Form!Text9)
All this works fine except when, as I move thru the records on the Products form, if there are no concommitant records in the subform (the subform is empty), there is no sum on the subform for [Text16] to reflect and and I get an error message. I use the nz function to try to convert null answers for [Text16] to zero, but that doesn't seem to help either.
Does anyone know why this is happening? Thanks for any help.
Robin