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

"Go to next record"-button command starts new record

P: n/a
I my form I have put record navigation buttons. When I choose just
before the last record, the "Go to next record" button, access
automatically start with a new record instead of a message that theere
are no records after.

I do have a command that automatically jumps to the last record after I
open the form:

Private Sub Form_Load()
DoCmd.GoToRecord , , acLast
End Sub

Bart
Acc 2003.

May 30 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
If you set AllowAdditions to False then Access will not (allow you to) go to a new record.

If you also need a working button 'NewRec' then you could do something like:
Private Sub NewRec_Click()
Me.AllowAdditions = True
DoCmd.GotoRecord , , acNewRec
End sub

Arno R
"AA Arens" <ba***********@gmail.com> schreef in bericht news:11**********************@u72g2000cwu.googlegr oups.com...
I my form I have put record navigation buttons. When I choose just
before the last record, the "Go to next record" button, access
automatically start with a new record instead of a message that theere
are no records after.

I do have a command that automatically jumps to the last record after I
open the form:

Private Sub Form_Load()
DoCmd.GoToRecord , , acLast
End Sub

Bart
Acc 2003.

May 30 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.