i have a linked table(tblxyz) having property set as ORDER BY ID DESC, ID is autonumber, so my table view gives me latest record on top.
now i have a subform , where i am calling this Table.....
[Forms]![MainForm]![Sub_DisplayFm].SourceObject = "Table.tblxyz"
this gives me datasheet view of the table inside subform but its not showing sorted data
interesting thing is it give sorted data view when my table is not linked and is in same access file.
now i have a subform , where i am calling this Table.....
[Forms]![MainForm]![Sub_DisplayFm].SourceObject = "Table.tblxyz"
this gives me datasheet view of the table inside subform but its not showing sorted data
interesting thing is it give sorted data view when my table is not linked and is in same access file.