I'm trying to find a way to show the results of several queries in a form and then a report. (I have a "laundry list" of "results" that I need to produce and want to put as many together as possible.

I tried txtTxtbox.text = docmd.runSQL " SELECT count[rest of statement goes here]"
and that did not work. Could someone point me in the right direction. The books I have here are on no help in the matter....

Thank,

Lroalee

You can do this. It depends on what the recordset looks like.

If you expect a single value, then you should open the recordset and take the field value you want as a string variable, and then post the string variable to the text box.



mmcdonal

Thanks. These are all single values, and I want something faster than a series of DCounts/DSums.

The final report is supposed to "look just like the paper version".

You could put a function in a module and then call the module. You might pass the PK from the detail section, and have the string returned by the function. So your On Format event for the detail section of the report would have:


txtTxtbox.text = MyFunction()


mmcdonal