Moving to the last record of a continious form

I have a continious subform which is only visible when the main form gets open.
The subform has a text box which is locked for the user.In order to enter something into it, a user has to click a button which will open zoom view and anything entered into the zoom view and clicked on Save button would get saved in the subform.
The problem is that whenever the subform gets visible the focus is always on the first record,when a new record is added the control doesn't go to the new record.It always comes to the first record.A user has to always scroll the subform to see the new record he/she has added.

How do I make it so when I see the subform through main form it automatically brings up a new record to be entered and not record 1.

or

After adding a new record how the control will come to the new record instead of going to the record 1.

re: Moving to the last record of a continious form

Hi. If you set the subform's Data Entry property to Yes you will restrict the form to entry of new records only. Please note that your users will not be able to edit (or even to see) existing records using that form if you set Data Entry to Yes (or, equivalently, to True using VBA code).

-Stewart

re: Moving to the last record of a continious form

But I need the existing records.Editing those records is not necessary.

Tell me one thing - is it possible to go to the last record of a continious form after inserting a new record?

re: Moving to the last record of a continious form

Yes it is.

Try out what's already suggested and you will see for yourself.