can text box show result of query?

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I want a text box to show the result of query, so
I dont have all the extra stuff of a subform. Or
do I have to use a combo box or list box?

for example, I have a form based on query as follows

ID Data OtherData
1 aa bb

and then I have another table

Data OtherData ITemI wantINTEXTBOX
aa bb ShowinTEXTBOX

HOw do I do this?
 
Perhaps the DLookup function will serve your purposes? See Help file for
more information about it. You can use an expression in the textbox's
ControlSource to run the function.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print labels rather than numbers from combo box 2
Cell Counter/Increment 2
Hierarchy 3
Select query 9
Error in Blank Field CrossTab Report 1
update table 2
Finding Matching data 6
Changing a 1 Row Table to 2 Column Table 3

Back
Top