Me.TALLOT.value = DSum("allotment", "allotment", "[UNIT_CODE] = '" & [COMSC] & "' AND [CODE_HEAD] ='" & [COMSNG] & "' AND and [finyear] = " & [COMFY])))
UNIT_CODE is a text field
CODE_HEAD is a text field
finyear is numeric field
i am geeting error 3075
UNIT_CODE is a text field
CODE_HEAD is a text field
finyear is numeric field
i am geeting error 3075