New record being added

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

urbano - 11 Sep 2007 17:14 GMT

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

Reply to this Message

Chris Reveille - 11 Sep 2007 17:48 GMT

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

Signature

Chris

> 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
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

SteveM - 11 Sep 2007 17:50 GMT

What is the code in your OnCurrent event procedure?

Steve

> 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
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

urbano - 11 Sep 2007 18:10 GMT

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

> What is the code in your OnCurrent event procedure?
>
[quoted text clipped - 8 lines]
> >
> > Thanks

Reply to this Message