The Text Box control does not have a record source property. Forms and
Reports have record source properties. What you have for a Text Box is a
control source property; however, since a text box holds only one specific
data item, a query may not be the best way to accomplish this. It may be
that a DLookup would provide you what you need. Be aware that if the control
source is not a field in the form's record source, the text box will not be
updateable.

Signature
Dave Hargis, Microsoft Access MVP
> Can someone tell me why i can't find the record source from text box
> under properties?
> The reason is i want to select a query source for my unbound text box.
> Can someone tell me why i can't find the record source from text box
> under properties?
> The reason is i want to select a query source for my unbound text box.
A Text control does not have a record source property.
It does have a control source property.
If you let us know what you are trying to accomplish, perhaps someone
can help you.

Signature
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
emerlita@shaw.ca - 08 May 2007 17:30 GMT
> > Can someone tell me why i can't find the record source from text box
> > under properties?
[quoted text clipped - 9 lines]
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
thank you to all, i think i got it. :)