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).
Code:
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.