Whenever I attempt to enter the following DSUM expression in the Control Source property of a text box on my main form, it generates the above-mentioned error message. Using it without the criteria works. Can someone please assist me off the ledge? I have been battling this for about three hours.
Here is my DSUM expression:
=DSUM(“[ThawEmbThwd]”,”qryEmbThawFile”,”[CryoFileID]= [Forms]![frmActCCHEmb]![frmEmbCryoFile_Sub].[Form].[frmEmbThawFile_Csub].[Form]![txtCryoFileID]")
Thanks,
Tarl105