Previos/Next Buttons (2002-SP3)

Topic

New Reply

I have buttons on a form to go to previous and next records.

How can I stop the next button from going to create a new record when it gets to the end of the records.
Here is the code for the button DoCmd.GoToRecord , , acNext

If you click on the next button one more time you get a message that says that you can’t go to the specified record. That’s what I want instead of switching to a new record.

Thanks

Paul

Reply | Quote

Replies

Set the form property Allow Additions to No.

Reply | Quote

If you set the Allow Additions property of the form to No, the user won’t be able to create a new record.

If you add

On Error Resume Next

at the beginning of the code, the user won’t get an error message if the button tries to go past the last record.

Reply | Quote

Hans-

I don’t thin that solves my problem.

I want the message – I just don’t want it to go to new record before I get the message.

Paul

Reply | Quote

Why doesn’t setting Allow Additions to No solve your problem? It’ll prevent the user from going to a new record.

Reply | Quote

That won’t work because I do have a button on the form to add new records. I just didn’t want the next button to take you to that screen.

Reply | Quote

You can set AllowAdditions to True in the On Click event of your “Add record” button, before moving to the new record.
Then set it to False again in the On Current event of the form.

Reply | Quote

That will work.

Thanks.

Paul

Reply | Quote