More Help Needed: RE: Changing The Text in a Report Field

[nilodor]

Allright,

I thought I had found success but alas it was snached from me.

From my other post:
Say I have a text box named text22 whose control source is a check box in a table called MainDB. What I want to do is if the check box is checked display a certain statement, than if the check box is unmarked I want to display different text. How would I go about doing this.

So what I have done is I created a query called CCheck, which has the code:
CC: IIf([Chem Check],"See Attached Records","No Records Attached") in the field, field.
This bit works fine and if I view the query is see either See Attached Records or No Records Attached

Now in my report I have created a text box that I referenced to the CCheck query.

So what I did was go into the control source of the text box and clicked the 3 little dots. Browsed through until I found the CCheck query and selected it.
So the code looks like =CCheck!CC for the code in the control source.

Now I thought this would work, sadly I am mistaken. When I view the report all I get is #Name? instead of the See Attached...

So what am I doing wrong? Any help would be very much appreciated.

 

[nilodor]

When I try and do this it no longer recognizes the data I have from my table in the form. Also it won't recognize the six other iif() statements I need to have in the report. Is there a way to have access link to the table as well as the queries that are based off the table?

 

[nilodor]

Hoo-ray

It works perfectly.

Thanks a lot.