Go to last record

K

Kevin

I have a subform (datasheet view) that requires entry by
users. It requires them to scroll down to get to the "new
record". Is there a way to automatically go to the last
record of the subform upon opening the main form?
Thank you!
 
L

Lee T.

On the properties of the subform add the following to the
ON CURRENT event.

DoCmd.GoToRecord , , acNewRec


hth

Lee T.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unremovable horizontal scroll bar on subform 1
Populate main form from subform record 0
Corrupt? Scrolling while viewing two pages side by side, pages go wonky? 0
Split form 0
Main \ Sub Form Data 1
Need cancel-save function on main form for datasheet subform 0
How do I clear a form? 0
Unable to delete subform records 11

Top