Discussion Locked

Creating report dynamically in Access 97

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

5 replies

by rebeccalbennett

One way to do this would be to put your query string either in a global variable, or in a hidden text box on your form. Then in the code for your report, refer back to that text box (if you choose that route) for the query source.

I've done thisbefore, though it has been a while. One of our current products uses a similar methodology. If you need any more help or explanation feel free to contact me and I'm glad to help.

Rebecca

This discussion is closed to new replies.