Stop next from going to new record

[gsnidow via AccessMonster.com]

Greetings all. Is there any way to prevent the next record button from going
to a new record? I have placed a next record on a subform with DoCmd.
GotoRecord,,asNextRec as the event code. From what I read on a post here
that is basically what happens when you hit the form's built in next button.
I would like to have it stop at the last record, rather than go on to a new
record. Is this possible? I tried using ADO to count the number of records
and populate that number in a text box, but it took too long for the form to
open. Thanks

Greg

 

[J_Goddard via AccessMonster.com]

Hi

Set the form's Allow Additions property to No.

John

 

[gsnidow via AccessMonster.com]

Thanks. Ok, that makes sense, but I also have a button to add a new record.
I guess I would have to have it set the additions property back to yes in
order to add a record?

Hi

Set the form's Allow Additions property to No.

John

Greetings all. Is there any way to prevent the next record button from going
to a new record? I have placed a next record on a subform with DoCmd.

[quoted text clipped - 6 lines]

Greg

 

[J_Goddard via AccessMonster.com]

Yes, that works. I use that, and I also set the DataEntry property to True
so that the users see only new records while adding, but in my case they may
add a number of new records at a time. They click another button to return
to No Additions.

HTH

John

Thanks. Ok, that makes sense, but I also have a button to add a new record.
I guess I would have to have it set the additions property back to yes in
order to add a record?

Hi

[quoted text clipped - 7 lines]