Column Control Source Property

[rts]

I did this in a form and it worked fine, but I'm having trouble in my report:



The report is based off of the "Project" Table. I have a field called "PM" in my Project table that is a look-up field to my "Contacts" table for a person's name . I want to set a text box's control source to be =[PM].[Column](3) to show that person's Phone Number. It worked fine for a form that I did, but it isn't working on this report. Is there something I'm forgetting?

Thanks

[June7]

Better would be to build the report RecordSource as a join of tables then all data from the related records will be available for display in textboxes.

[rts]

I thought that, I was just trying to take a shortcut Is there any reason why it worked before and isn't working now? I even tried it in a form again and it didn't work, but a form in the same database works that way. Is there some property I can check just to be sure?

Thanks!

[June7]

I would have to review the project.

[rts]

Here are 2 snap shots of the properties of each text box. It looks the same to me, but I don't know if I've forgotten a step. And "ST_TO" and "MCC_PM" are both linked to the Contacts table as look-up fields for a person's name. I don't have the Contacts table linked to either of the forms, but it isn't working on "MCC_PM." Anything helps, meanwhile I'll try doing it the right way.

[June7]

I can't determine cause from those images either.

[rts]

Wow, you're idea was way easier Thanks!