By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,207 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Moving to the last record of a continious form

P: 18
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.
Oct 21 '08 #1
Share this Question
Share on Google+
3 Replies


Expert Mod 2.5K+
P: 2,545
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
Oct 21 '08 #2

P: 18
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?
Oct 21 '08 #3

NeoPa
Expert Mod 15k+
P: 31,494
Yes it is.

Try out what's already suggested and you will see for yourself.
Oct 22 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.