Resorting Records

[Enrico]

I have a form that allows users to input data in records. One of the fields uses the autonumber option. When more than one person works on the form, the autonumbers will not be in order(say 100,102,101). Even when I close everything and filter the column on the table, the numbers on the form never appear in the correct order. Is there any way to have the form display the numbers in the corrected order that the table has? Thanks in advance.

Enrico

 

[DML]

Is your form bound directly to the table? If so, you can make a query out of the table that the form is bound to. In the query grid, select the sort option for the field or fields that you want the data sorted by . Bind your form to that query instead of just the table.

 

[Enrico]

It worked. Thanks for the advice. One quick question, though. Is it all right to use a query instead of a table to house my data, or should I just use the query to update forms when I need to? Thanks again.

 

[DML]

I am not sure I understand the question, but a table is where your data is housed (always). A query is a way of viewing (and manipulating) that housed data. You could actually experience a performance increase by using a query in some cases.

A little House Cleaning Tip: If you begin to use more queries, it will be helpful if you give those queries very meaningful names so that you will remember what they do later. (I also add descriptions for my queries -- right click the query and choose properties to add descriptions for them)

If I didn't answer your question, try asking it again.

Good Day!

[This message has been edited by DML (edited 07-07-2000).]