I have a Textbox on a subform that uses the following Control Source statement: =DSum("[EstLabCostExt]", "ProdLabT", "[ProdID] =" & [tboProdID] & " AND " & "[OpsID] = 32"). If the particular product doesn't have a record in ProdLabT yet an error is returned in a field on the main form that references the field on the subform. Is There something else I need to do?
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 11.
