Go to last record

  • Thread starter Thread starter Kevin
  • Start date Start date
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!
 
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
Going to first record 0
Go to specific record on form 4
Force Autonumber to generate 0
Subform of subform not being linked 3
Main \ Sub Form Data 1
Remove filter from form but stay on current record 5
Disappearing records in datasheet view 1

Back
Top