Hi,
I am using Access 97.
In Access 97 I am using a form to generate a dynamic query.(Using the Build Event – Code of a Command Button I am writing Visual Basic code to generate the dynamic query from the user input in the text and check boxes on the form).
I am successful in creating a query dynamically, based on user input from a collection of text boxes and check boxes.
Now, I want to generate a report each time this dynamic query is run. Ofcourse, I do want to delete the earlier report generated by this query.
Please let me know how do I do this?
Many Thanks in advance,
Porella.