This Control Has an Invalid Control Source

[ryguy7272]

I am adding a few TextBoxes to a Report. All went in fine, except for one.
I have a little green triangle in the upper left hand corner and a message
that reads ‘this control has an invalid control source’. I go to Properties
> ControlSource > … > then open the query that this TextBox is supposed to be
linked to and double-click the field in the query to get this: [ExecBroker]
«Expr» [QueryWorking]![ExecBroker]
I deleted the first part and ended up with this:
= [QueryWorking]![ExecBroker]
Access doesn’t like that very much because it gives me an #Error when I view
the report.

Then I delete everything in the Control Source so I have this:
[ExecBroker]
Then the green triangle is back!!

Why is Access doing this for just one field?

Thanks,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

[Allen Browne]

Does the query output *two* fields both named ExecBroker?

No: then use use a Control Source of:
ExecBroker

Yes: then alias one of the fields in the query, by preceding it with another
name an colon, e.g.:
OtherExec: [SomeTable].[ExecBroker]
Then in your report, use this alias in the Control Source.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ryguy7272" <rygu...@discussions.microsoft.com> wrote in message
news:C036ADDE-ADC0-4D76...@microsoft.com...