Sorting the Order in A Form

[Sbufkle]

I have a form set up so the user can 'flip' through the database in a better looking environment than the usual plain columns & rows.

I had originally 700 items, all alphbetically ordered when I created the form. But now I added a new entry, & it doenst go into the form in its alphabetic spot.. its the first item now..

I treid goign to table & sorting them alpahbetically.. which it did, but int he form its still whacked out.

I guess I slept a tthis part of one of my 3 Access courses I took!!

WHAT DO I DO!!!

 

[Norie]

If your form is based on a query you could sort on the field you want.

If it is based on just a table then change it to be based on a query and again sort on the field you want.