I want to sort my OrderID descending in a form. I wrote my row source as:
= SELECT [OrderT].[OrderID] FROM [OrderT] ORDER BY OrderT.OrderID DESC
The error message is:
The syntax of the subquery in this expression is incorrect.
Check the subquery's syntax and enclose the subquery in parenthesis.
Please rewrite my statement correctly so that I can see how it should be.   Thanks

---

Reply from Alex Hedley:

If you create a Query and set the Row Source to your Query does it work?