If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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''. |
#2
|
|||
|
|||
This Control Has an Invalid Control Source
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''. |
Thread Tools | |
Display Modes | |
|
|