Record source from text box under properties

E

emerlita

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

Klatuu

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

fredg

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.
Click to expand...

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

emerlita

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.
Click to expand...

thank you to all, i think i got it. :)
 
Top