Query as Pop Up, is it possible?

[ldiaz]

Hello there!

Is there an option, or how can I run a Query as Pop up mode?

What I want is that the user can see the results in Crosstab query but I
want they do not have access to see the query in design mode neither make
changes,

I would like a pop up query but not a maximized window and the only option
that the user can see is the Close Botton, and another button to print the
query, is it possible?


Note: using sub-form does not work since in the crosstab appear some main
field that when the sub-form was built they were not there, and this cause
the sub-form show an error because there are new fields and some other does
not appear

Thanks
LD

 

[SteveM]

You can use: DoCmd.OpenQuery "QueryName" , acNormal, acReadOnly

The acReadOnly attribute ensures the user cannot change anything in an
updateable query. You can press Ctrl+P to print it.

Or use a report.

Steve