Date sort in subform incorrect in. Query is correct

[karassik]

I imagine this might be something common, so just point me to a previous post, I couldn't find it.

Problem is that my query is sorted by Ascending date which works perfectly in the datasheet view. Although when I use it in my continuous subform, it doesn't sort correctly.

Any ideas?

Thanks in advance,

Nishan

 

[Rolliee]

The recordsource of a subform is itself a query. If you click on that query, you will, no douobt, find it is different than the other query you reference. Yoiu may copy the query you like in the clipboard, open the subform query and paste it in - thus being sure it is the same query OR you may add an ORDER BY ... to the suvformj query.

rollie@bwsys.net