Result of the query displayed in text field.

[Peter3]

Hello,



Can you advise me?
Is it possible to insert in the report a text field in which the result of the query will be displayed depending on the selected option ?

E.g.
One text field and 5 buttons - pressing the button displays the result of the selected query execution in the window - pressing another button dynamically changes the contents of the field (another query).

Sub button_Click()
-- run QUERY1, and display in the report field
End Sub

How do I run a query from VBA and assign its result to the report field?

Thanx a lot in advance.
Best Regards.

[Minty]

A query will return a result set, that you can base a report on. I don't see how you could a result set for just one field.
However if your queries return a single record which is one value, you could simply change the record source of the report, provided the result field is called the same for each query.

Alternatively if the queries are simply producing some form of summed result you could probably use a simple DSum or DCount in the report.

[Peter3]

Not really like that.


In the case of a simple query result, which has one field (sum or count), I can assign them to the text field in the report (using a variable).

Now I need to assign a query result to the text field, which is a table (5 columns, 20 rows). I have several such queries and I would like to control the buttons and display the selected results.
I saw such a solution, but I do not know how it was made. How to achieve it the easiest way? Is there a simple method? Could you advise something?

[aytee111]

There seems to be some confusion over this. You have a report with a text field - where are the buttons that you are clicking on, are they on the report itself? Then you say the text field is a table - a table in Access is an object which stores data, so what are you referring to here? Please provide more details as to your process and how to get to where you want the field displayed.