n00b question. Input forms...

[Ecron]

Hello,

When I open an already created form just linked to a table to input new information. At the bottom is says, for example, 1 of 30. How can I make it so that it just adds a new entry at the end of that 30, being 31? And then, perhaps sorting the table... after all the data has been entered. Your help would be much appreciated!!

Thanks!

 

[antonyx]

open your form in design view


click view.. then code

then paste this below Option Compare Database

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

 

[Ecron]

I'll give it a shot when I get back to my computer...

Thanks alot!