Order by not working

Question

I have a form with two sub-forms that I use to edit an SQL database.

When I filter records on the main form, my order by property on the sub-form does not work.

If I don't filter the records on the main form the order by property on the sub-form works well.

Why does the order by property on the sub-form not work wile records are filtered on the main form?

Answer 1

Thanks again Duane.  I made an access query of the ODBC linked SQL table.  Then I set my sub-form record source to be that query instead of the table.  In that query I set the YTC field to sort ascending and my sub-form records are in the order I need.

John Green

Answer 2

Thanks. My ORDER BY  is a form property.  I'll try to apply it to the record source and let you know what happens.  I don't have much experience with SQL but I do know how to get into SQL management studio.

Answer 3

Is your ORDER BY in a form property or in the record source SQL/query? I almost always apply the ORDER BY in the record source and haven't experienced any issues.

I expect the filtering of the main form requeries the subform.

BTW: "Question" isn't a very good subject line since every post in this forum is a question. It might have been better to use "Issue Sorting in subform" or similar.