Going to a new record when a form opens is not the default behavior in Access,
at least not up thru v2003. I suspect that this holds true for v2007, as well,
although with Microsoft, anything is possible. Which means that, possibly
inadvertently, you've probably instructed Access to open to a new record, and
you need to figure out how you've done this and correct it.

One way to do this is to set the form's Data Entry property to Yes. I don't
think this is what you've done, because it ***only*** allows for new records
to be entered. You can't ***view existing records at all*** if this property
is set to True, which you state you can, after sorting the records.

Another way to accomplish this, if your form is being opened from another
form, is to instruct Access to open to a new record with code like this

DoCmd.OpenForm "YourFormName", , , , acAdd

Lastly, in the form's OnLoad or OnOpen event, it can can do it with code like
this:

Private Sub Form_Load()
 DoCmd.GoToRecord , , acNewRec
End Sub

I suppose, in this last instance, you could have a macro called from the
OnLoad or OnOpen event that instructs Access to do this, so if you have a
macro in either of these places, you'll need to check them out as well.

Good luck!