Access query that is not modifiable

[clevelandjwb]

I have a button which runs a query. It displays properly. I would like to make it so the only thing the user can do is close the query by using "X". As it is now, the query can be placed back into design mode and modified. Any idea how to do this?

 

[HarleyQuinn]

Output the query to your own form, limiting the controlbox options.

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[dhookom]

You can actually create a main form with a subform object. Then set the Source Object to your query.

Duane MS Access MVP