This Control Has an Invalid Control Source

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''.

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" wrote in message
...
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''.