[2k3] Form editor, circular reference ?

[Richard]

A form contains an unbound text box named "TicketID" with a
ControlSource
=DLookUp("[TicketID]","tblButtons","[ButtonNumber]=""" &
[ButtonNumber] & """")

The box has a
- little green triangle in upper left corner of unbound text box
- what other visuals might form editor show?
- exclamation diamond

the diamond drops down a menu with highlighting on
- Invalid Control Property:Control Source
- Circular Reference

Nothing seems 'wrong' when the form runs, but why would access
indicate a circular reference?

 

[Guest]

Although your text box control is unbound, it sounds like your form isn't.
If the form's recordsource returns a field named 'TicketID' then a control on
that form with the same name can't use an expression as its control source.

The solution here is to rename your text box. I suggest 'txtTicketID'.

 

[Richard]

Although your text box control is unbound, it sounds like your form isn't.
If the form's recordsource returns a field named 'TicketID' then a control on
that form with the same name can't use an expression as its control source.

The solution here is to rename your text box. I suggest 'txtTicketID'.

Elwin calls it like it is! Thanks.