How to display query result in text box?

[hkgary33 via AccessMonster.com]

Dear all,
I’ve built a form that can be divided into two parts. The left-hand part is
for the user to input certain criteria in the textboxes for searching, after
clicking the “search†button, then the relevant search results will be shown
in the right-hand part of the form. I’ve successfully designed the criteria
controls and the query, but how can I display the query results by means of
the textboxes in the right-hand part of the form? Since I don’t want the
query results to be pop-up in the default datasheet view, I just want to show
those results in that form.
For example, after the query runs, it will have 3 cells containing the query
results, how can I get these values and then show it in the 3 textboxes in
the form? How can I set the Control Source of the textboxes?

Thanks a lot!
Gary

 

[fredg]

Dear all,
Iÿve built a form that can be divided into two parts. The left-hand part is
for the user to input certain criteria in the textboxes for searching, after
clicking the ´search¡ button, then the relevant search results will be shown
in the right-hand part of the form. Iÿve successfully designed the criteria
controls and the query, but how can I display the query results by means of
the textboxes in the right-hand part of the form? Since I donÿt want the
query results to be pop-up in the default datasheet view, I just want to show
those results in that form.
For example, after the query runs, it will have 3 cells containing the query
results, how can I get these values and then show it in the 3 textboxes in
the form? How can I set the Control Source of the textboxes?

Thanks a lot!
Gary

Answered elsewhere.
Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), cross-post by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.