[AccessD] Order By

I ran into a slight problem today. I've gotten passed it, but I am still
curious.

I designed a form and tried putting into order by a control number. To
do this I figured I had to add it to the "Order By" property of the
form. However, this did not give me any results. What I ended up doing,
in the essence of time, is put a SELECT statement in the Control Source
of the form, ending in an Order By statement.

Why wouldn't this work the first way?

John Clark