Disallow edits to saved query

[MWMike]

Hi all,



I have a subform bound to a query displaying in datasheet view, and I like the ability to use the built-in arrows in the field names to further filter and sort the query results. However, if I use a filter and then close the form, I get a pop-up asking if I want to save the changes to the query. I don't want the user to be able to change any of the queries. I tried using the 'enabled' property, but that makes the filter/sort unavailable. Is there some other way I can enable the filter/sort but not allow edits to the saved query?

Thanks

[MWMike]

Forgot to mention that I also set the subform property "Locked" to Yes, assuming that would solve my problem, but it doesn't seem like that does anything at all.

[MWMike]

Bump.

Still having an issue with this. Does anyone at least know what I'm talking about? I have a subform displaying the results of a query, and whenever I use a filter or sort, or even resize a column, and then close the form, I get a message asking if I want to save the changes I made to the query.

Now, I am still in design mode here, and will eventually split the database and deploy on other clients. Maybe this won't be an issue then?

Or maybe I can write a piece of vb code to suppress / click 'no' when the warning pops up?

Or maybe I can somehow set the query to read-only?

I need a little direction here, there must be a solution to this...