Sort Query

[esskaykay]

I have a query that has four fields. One is used only as a sort field. It works fine. However, if someone resorts the open query on one of the other fields (not the one used as the sort in the query), then inadvertently says “yes” to save when exiting, the next time they open the query, it is sorted by the field last sorted on, not the one set in the query

This is no biggie but just an annoyance. Any suggestions?

Thanks,
SKK

 

[mhartman]

What can we help you with?

 

[esskaykay]

We have a data entry form with a command button that opens a query where our sidewalk inspector enters construction dates. He wants the query sorted by "address". There is a Notice_ID field he also wants to see. If he resorts on the Notice_ID then inadvertently says "yes" to save when exiting, the next time he clicks on the button, the query opens sorted by Notice_ID not Address as is set in the query.

Thanks,
SKK

 

[pbaldy]

One of the many reasons most of us don't expose tables or queries to users. Present it to them in a form they can sort to their heart's content. You control everything then.