In Microsoft Access 2000, how do you sort or filiter records using a form in the orde

[seekquaze]

For a project I am working on I am having to use a Microsoft 2000 database that was meant for another project and adapt it. So far everything is working out fine, but whenever I input records using a predesigned form it puts them in a different order than that of which I entered them. The table still displays the records in the order of which I inputed them, but the form redoes them in I think alphabetical order. So, when I go through the records in the form they are in another order other than the one I inputed them. The basis of this seems to be a "find record" drop down box that sorts them alphabetically. According to a person who has used the database before the box has always done that, but it has never affected the order of the records.

The records are already sorted on the table by autonumber. What I want to know is how to get the order they are on the table to be the order of the forms. Example: On the table the records are ordered 1, 2, 3. But when going through the records on the forms they are ordered 3, 1, 2. When viewing the records on the forms and not the tables how do I get it ordered to be 1, 2, 3.



So, what do I need to do so when I go through the records in a form view they are in the order I inputed them and not in another order?

[pbaldy]

It is a mistake to rely on the order of records in a table. It should be thought of as a bucket that holds data in no particular order. You sort it when you view it via query, form or report. In this case, you can base the form on a query that includes the appropriate sorting, or set the OrderBy and OrderByOn properties in the open event (might be the load event).