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

 

[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

Reply to group, rather than allenbrowne at mvps dot org.

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