Stop next from going to new record

  • Thread starter Thread starter gsnidow via AccessMonster.com
  • Start date Start date
G

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
 
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?

J_Goddard said:
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.
Click to expand...
[quoted text clipped - 6 lines]
Greg
Click to expand...
Click to expand...
 
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
Click to expand...
[quoted text clipped - 7 lines]
Click to expand...
 
Back
Top