Continuous form changed by other users

[Guest]

I use Access 97 in a multi user environment. I have a continuous form (based
on a sorted query) with some buttons that use DoCmd.ApplyFilter and
DoCmd.ShowAllRecords. My problem is that sometimes when the user exits the
database, they are prompted that the form has been change by them or a
different user. I have taken away the users ability to go to design view so
I am sure that they are not changing the form on purpose.

I have also noticed that the OrderBy on the form keeps growing from the
normal 2 fields, as per the query the form is based on, to those same 2
fields repeated several times.

How can I keep the user from continually being prompted to save this form?

Thanks

 

[Guest]

Any ideas? I can give you sample code for the ApplyFilters.