A number of queries to run off one form

[Chimp8471]

I have set up a number of queries that are run dependant on data entered into various forms, this sets the criteria for the query.

I am looking to compile a number of graphs in a report using the 4 queries that i have. however these all run off of different forms.

What i want to do is create a new form and then run the 4 queries similaniously using just the one new form.

I do need to keep the other forms as well, this is just an added requirement........hope this makes some kind of sense.

Cheers

Andy

 

[The_Doc_Man]

Well, you can run the queries from a single form. The question is to decide the triggering event. Perhaps a button you can click when ready? In any case, you make a subroutine to run your queries. OR generate your reports directly, since if the reports use a canned query as a recordsource, they would run it when you opened the report.

So in summary, you CAN do what you said you wanted to do. The trick will be to figure out where to do it. And there, we can only offer limited assistance. I'm voting for a button-click, but it is your form and your project.