I have about 40 or so textboxes that are all performing a Dsum when my form opens. The code resides in the unbound textbox and looks like this:
Is there any advantage to doing these Dsums in VBA, assigning the value to a variable and putting that in a textbox using Me.Txtbox.value = Value?
Code:
= Nz(DSum("WorkingDays", "UniQryFiscalUsageToDateDashboardNew", "CategoryID = 1")) + Nz(DSum("UsageDays", "qryFiscalEquipmentDaysRapidProto", "CategoryID = 1"))
Is there any advantage to doing these Dsums in VBA, assigning the value to a variable and putting that in a textbox using Me.Txtbox.value = Value?