I just don't see it.
As one can see from the composite screenshot, DLookup should be returning a value of 16 from the table tblAccounts. (Debug clearly shows correct value for criteria)
Is Access getting mixed up because field names are the same in both tables tblChkReg and tblAccounts?
Thanks,
Bill