Open a Form at last entry of table 1

[womper]

How do I open a form at the point where my user can just start to input data without having to go to the last entry of the table before starting? The only order of the table is that the date is in descending order. I don't want my user to unknowingly start typing over existing records in the table.

 

[Eupher]

In the form's Open event:

DoCmd.GoToRecord , , acNewRecord

Ken S.

 

[Eupher]

Oops,

DoCmd.GoToRecord , , acNewRec

Ken S.

 

[womper]

Thank You.
I guess this goes into the sub routine that opened up when I created an event for On Open of the form I am using.

 

[Eupher]

Yes, that's right.

Ken S.