Bound Form Order

[Purdue15]

Hello Everyone,

I have a report that generates 100 items in alphabetical order. All of the items are also displayed in a table. I have a bound form attached to the that table, and when the items appear they are not in alphabetical order. Therefore, it is a hassle typing in the data when the form will not appear in order, because instead of going in order I am flipping through pages. What is causing this to happen? And what can I do to fix this?

Thanks

 

[pbaldy]

You can base the form on a query that includes the desired sort.

 

[Pat Hartman]

All data is returned via a query even if your form/report is bound to a table. The database engine returns records at its convenience and order is not defined unless you specifically use an Order By clause. This behavior is standard for all relational databases, not just ACE/Jet.