Open at new record.

[Hans]

We are having a tough time keeping entries from being overwritten in our new database. How best to open the form (data entry) to the first unwritten record, eliminating the hassle of clicking to the end each time they open it?

 

[donbettis]

If I understand what you are wanting to do... You could place the following into the OnOpen Event of your form...

DoCmd.GoToRecord , , acNewRec

Hope this helps...

Don

 

[mrabrams]

Another option is setting the form's Data Entry Property to YES.

 

[Hans]

Thanks! Both do the trick!