J
John
I have a mainform with a tabcontrol and on a tab there is a subform on
it. The subform has a total txtbox on it that totals the quantity of
items in the subform. The txtbox on the main form then shows the
quantity. The controlsource on the mainform has
=[zPurchaseOrderItems].[Form]![txtTotalQuantity] that does show the
quantity. But if the status is Void, there are no items showing in
the subform and I get #Error for the quantity. Going to one of those
voided records gives expression error. What is the work around for
it?
Thanks.
.... John
it. The subform has a total txtbox on it that totals the quantity of
items in the subform. The txtbox on the main form then shows the
quantity. The controlsource on the mainform has
=[zPurchaseOrderItems].[Form]![txtTotalQuantity] that does show the
quantity. But if the status is Void, there are no items showing in
the subform and I get #Error for the quantity. Going to one of those
voided records gives expression error. What is the work around for
it?
Thanks.
.... John