View Full Version : Open at new record.


Hans
02-06-2002, 05:34 AM
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
02-06-2002, 05:57 AM
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
02-06-2002, 06:54 AM
Another option is setting the form's Data Entry Property to YES.

Hans
02-07-2002, 09:12 AM
Thanks! Both do the trick!