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.
Thanks! Both do the trick!