hiding queries behind a macro

[magick]

i have numerous macros that run a series of queries to get the results for a
report. In 2003, the macro would run and only display the report. a new
macro that i created in 2007 opens the report, but also opens all of the
queries behind it in dataview, which i don't want the users to have to see
and close. how do i change this in 2007? thanks!

 

[Steve Schapel]

Magick,

What sort of queries are these? Are they Action Queries (e.g. Append,
Make-Table, Update) or are they Select Queries? If they are Action Queries,
I can't understand how they can open in datasheet. If they are Select
Queries, I dcan't understnad why you would be running them.

 

[magick]

you are so right - i had 2 make-table and 1 append but had also included 2
select queries that the report is using in the macro (unneeded). thanks for
jogging my brain.