New record being added

[Guest]

When I am going thru my records in a form, I get to the end of the
records(the last record) and usually it would have a blank primary key. But
not anymore, it creates a new number since the primary key is AutoNumber. I
created a VB procedure in the On Current property, would that be the reason?
How can I avoid this? Is there a way to stop the user to going to the New
Record?

Thanks

 

[Guest]

If you do not want the use to add new records set Allow additions to NO

 

[Guest]

What is the code in your OnCurrent event procedure?

Steve

 

[Guest]

Thanks for your response. The code was actually populating a field which was
making the autonumber react. I took that off and now it is ok.

Thanks