I'm hoping someone can help with this one. I've been stuck on this for weeks and have been unable to find anything by searching online.
I have several forms and reports with text fields on them in which i enter expressions to look information up on certain forms or reports.
Form ControlSource Example:
=DLookUp("[Min]","qryCust","[CID] =" & [Forms]![frmFlip]![CID])
Report ControlSource Example:
=DLookUp("[Min]","qryCust","[CID] =" & [Reports]![rptFlip]![CID])
Here is what is happening:
Form ControlSource Example:
=DLookUp("[Min]","qryCust","[CID] =" & [Forms]![Form]![CID])
Report ControlSource Example:
=IIf(IsNull(DLookUp("[CID]","tblCoApp","[CID] = " & [Reports]!Report!CID)),"","and " & DLookUp("[Name]","tblCoApp","[CID] = " & [Reports]![Report]![CID]))
It appears Random but I'm sure there is some method to the madness. Access is "forgetting" the actual form or report name in the control source expression.
My access db is 2000. Any help would be greatly appreciated!
Thank you in advance.