Form Subform reference issue
Posted on 2014-02-05
I have this in the control source of a field on a form:
=DSum("[ShipQty]","tblShipmentDetails","[ReadyID] = " & [Forms]![subfrmReady]![txtReadyID])
But it doesn't work and I think the reason is because I have to somehow reference the main form prior to the [Forms]![subfrmReady]![txtReadyID] part of the line.