Sorting Problems - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Sorting Problems

Richard Van Wagoner

3 years ago

I am having problems with sorting with a query and a form that it is associated with. I am attaching some screenshots to help demonstrate this problem. I have deleted the form and redid it but my form does not accept the results of the query sort.

	Richard Van Wagoner OP @Reply 3 years ago

	Richard Van Wagoner OP @Reply 3 years ago

	Richard Van Wagoner OP @Reply 3 years ago

	Richard Van Wagoner OP @Reply 3 years ago

	Kevin Robertson @Reply 3 years ago
Remove the value in the Order By property in the Property Sheet (Form Properties). It is over-riding the sort in the Query.

	Richard Van Wagoner OP @Reply 3 years ago
Thanks that worked! But I don't remember setting that property. Could something else set it?

	Kevin Robertson @Reply 3 years ago
Possibly. I would also set Order By On Load to No. That way if the Order By property is set for some reason it will be ignored when the form loads.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View