New record being added

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
If you do not want the use to add new records set Allow additions to NO
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Force Autonumber to generate 0
Pop-up form that creates record that links 1:1 to main form 0
Autonumber is reusing previously assigned numbers-creating duplica 3
Subform within Subform Relationship is Indeterminate 4
Cannot Add new record, then disable AllowAdditions 2
primary key duplicate record is not incremental 2
new subform entry for existing record 3
Force new record if omitted 6

Back
Top