=DLookUp("Amount_ Aggregate","tblDraws","ID=" & [DrawIDrpmt])
similarly, do the same for the 2nd function:=DLookUp("Amount","tblDraws_Details1","DrawIDrpmt=" & [ DrawIDrpmt])
this will give you clue which part is getting an error and let you handle that error more efficiently.
I imagine its a parenOr missing Operator?
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.