
Originally Posted by
SFC
Hi pkstormy,
I'm trying to add your info into my report but having a little trouble becuse of my in experience, maybe you can help me.
In my report I have a text field "Note-1", this text field currently shows what is in the form text boxt with this control source; =[Forms]![Form1]![Note1])
I tried adding the expression you offered like this; =[Forms]![Form1]![Note1]=IIf([Forms]![Form1]![CheckNote1]=False,[Note-1],"")
This gets flagged by Access and states "Invalid Control Property: Control Source" and "Circular reference"
So when I do a print preview of the report when the check box is true the Note-1 field displays "0".
When the check box is false it displays "#Type!"
I will continue to try to work it out but if you have any more comments that would be great!
Thanks,
Steve