New Record First

[smallh]

I have a contact log which I display them in descending order. The only problem with this is that I the new record is all the way at the bottom of the form. Does anyone know if there is a way in Access 97 to put the new record as the first record displayed??

 

[Mile-O]

On the button that opens the form:

DoCmd.OpenForm "MyForm", , , , acFormAdd

OR


In the Form Load event of the form you are using:

DoCmd.GotoRecord, , acNewRec

The former is best advised.