Form Properties - Order By Issue

[skp]

I have several forms, all of which have a lot of data entries in them. Every one of the forms is to be ordered by Name...and I have all but one that works. No I compared all properties between all forms, but I have one form that will not order by anything that I enter in the "Order By" section. The form information only displays in order that it was entered and cannot be changed...and I cannot figure out why! Any help would be appreciated, it seems this is the last issue I have before this project is complete.

SKP

 

[boblarson]

You should be using a QUERY for the recordsource of each form and set the order by there. I would not be relying on the form's order by property. I use it sometimes but as a general rule I would order in the form's underlying query.