i know that if i want to sum the subform's records for a particular field i can put a textbox in the header or footer with the control source of "=sum([fieldname])"
however, how can i do it with VBA?
i want to sum it based on the subform's recordset not a dsum using the same criteria. essentially what the user sees should be what is being summed. (excluding filters - they're disabled = )) )
thanks in advance guys!!!! = ))