Hello I kinda found a solution but i am trying to make it work a little better. I want to run 2 saved queries with the push of one command button through VBA.
I know I can just
Does this make the queries visible or are they hidden?
If they are hidden how do I close them after I have run them?
If I order them like that will it run 1 then 2 because 2 needs info from 1?
I know I can just
Code:
DoCmd.OpenQuery "Name of Query1"
DoCmd.OpenQuery "Name of Query2"
Does this make the queries visible or are they hidden?
If they are hidden how do I close them after I have run them?
If I order them like that will it run 1 then 2 because 2 needs info from 1?