Sorting records on a form in an ADP file.

[seanward]

I can't figure out how to get the records in a form to sort automatically on open with a MS Access Project. It is based on a View which apparently only can't be sorted. The SortBy property on an Project is ignored. How do I sort the records on this form?

 

[seanward]

When I try to specify order by in the view it tells me order by clause may not be used in this query type.

 

[seanward]

I got it, I had to specify top 100 percent in the query for it to allow sorts.