Form won't match query sort order

[TomK via AccessMonster.com]

OK, this is starting to drive me a little crazy now...and I'm sure I'm
overlooking something obvious. I have a form that is bound to a query. The
query is set to sort on Field_1 (Ascending), then by Field_2 (Asc), and when
I run the query it is sorted correctly. But, when I run the form that is
bound to it, the sort order insists on being by Field_3. I've tried just
deleting the Properties:Sort Order for the form and I've also tried setting
it to Field_1, Field_2. But, when I open the form it sets it back to Field_3.
What the heck is going on here? Appreciate any help!

Thanks,
Tom

 

[Allen Browne]

A form should work as you expect, but if you are stuck you might set
OrderByOn on the Open event procedure of the form.

This kind of thing:

Private Sub Form_Open(Cancel As Integer)
Me.OrderBy ="[Field_1], [Field_2]"
Me.OrderByOn = True
End Sub

 

[TomK via AccessMonster.com]

A form should work as you expect, but if you are stuck you might set
OrderByOn on the Open event procedure of the form.

This kind of thing:

Private Sub Form_Open(Cancel As Integer)
Me.OrderBy ="[Field_1], [Field_2]"
Me.OrderByOn = True
End Sub

OK, this is starting to drive me a little crazy now...and I'm sure I'm
overlooking something obvious. I have a form that is bound to a query.

[quoted text clipped - 8 lines]

Field_3.
What the heck is going on here? Appreciate any help!

Eureka! Thanks Allen!! You pointed me in the right direction. Turns out
there was already a Me.OrderBy ="[Field_3]" line in there that I didn't know
about. That explains it.