Insert a query result into a form or text box

[scubadiver]

Hello,

I have a combo box of queries so when I choose a query it opens separately.

I found a database with a dynamic form that places a query result into a
text box. It is similar to what I would like but my queries are "totals"
queries with calculated percentages.

So what I would like is to use the after update event of the combo box to
place the query result into a text box.

What is the best way to go about doing this?

cheers

 

[scubadiver]

Probably not clear enough.

I have a list of queries and I want to choose which query I show in the text
box.

thanks.

 

[Klatuu]

If your query returns just one value, why not just use a DLookup?

 

[scubadiver]

Hello,

I know I haven't explained myself very well

This is the form I looked at.

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='DynamSubFrm.mdb'

It is not too far from what I would like to have. The VBA code uses one SQL.
My list of queries have different SQLs

I have made some progress

 

[scubadiver]

I managed to work it out. I had used a text box instead of a subform!

 

[Klatuu]

I am getting an error trying to go to the link you supplied.