Hi Evan, I made a mistake with the syntax, hopefully this works for Me.txtSpacing.ControlSource:
Code:
=Abs([sysHop1]-DLookUp("[sysHop1]","tblSystemConfiguration","[sysAccountID]=" & [Forms]![frmSearchSchools]![accAccountID] & " And [sysSystemConfigID]=" & Nz(DMax("[sysSystemConfigID]","tblSystemConfiguration","[sysAccountID]=" & [Forms]![frmSearchSchools]![accAccountID] & " And [sysSystemConfigID] <" & [sysSystemConfigID]),0)))