automatically sort table entries

i have my tables sorted alphabetically, but when i add a new record i have to
go and reapply the sort again manually...
i want to have the sort apply automatically every time i add an entry (ie.
the entry should "find its spot" alphabetically in the entries of the
table)...
can anyone help me?

thanx

A table is a collection of records. The database retrieves those records in
no particular order, unless you use SQL commands to do so with a query.
"Sorting" the table column display will only work for the current data set.
As soon as another entry is added, you will need to manually resort the data
set. Essentially, you have been "pushing on a string."

Instead, create a query that sorts the entries on the field or fields that
you want alphabetized. You can create a bound form that uses this query as
its RecordSource. As soon as you add an entry, you can set the form so that
it will "requery" the database and retrieve the records in the order that
you set when you designed your query. Using a form bound to a query instead
of a table for the data input provides event procedures to help control the
data input and provides data validation, so you receive added benefits as
well.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)


"fvela" wrote in message
...
i have my tables sorted alphabetically, but when i add a new record i have
to
go and reapply the sort again manually...
i want to have the sort apply automatically every time i add an entry (ie.
the entry should "find its spot" alphabetically in the entries of the
table)...
can anyone help me?

thanx