Go to LAST RECORD in subform

[JAD]

I have an Access DB that uses forms to enter the data. One of the forms it has multiple tabs (subforms). All the subforms except the one in question have a one to one relationship. The one-to many (daily report) subform is giving me problems. Sometimes when I open the daily report and go to the end to add a new day I fill out the various fields and when I hit enter or page down it jumps back to the start of the records. Any idea how to always advance to the next or blank record rather than having to page down through all the days again? Or if I wanted to page up it should go to the previous day.
For some reason this does not happen all the time. Generally it is just the first time I start to enter data on a record that has lots of days.
Thanks!

 

[MStef]

Look at "DemoSubNewRecordA2000.mdb" (attachment, zip).
Look at VBA.
Open "frmMAIN" and try.
I think it is what you need. Adapt it in your MDB.

 

[vbaInet]

I have no doubt that MStef has something good for you in this sample db, but just to mention that this kind of problem normally happens when you Requery a form. Just fyi.