Microsoft Access Autonumber Key problem (1 Viewer)

[asadkhan]

Hello Sirs,

I have a form which recently started behaving strangely; the primary key is Autonumber, when I save my record by tabbing out of last field, it goes straight to next new record and shows a next number in the Autonumber primary key, instead of showing (NewRecord) entry in the autonumeber primary key. Same thing happens when form opens. The nature of database requires that new record entry/record should only start/created when first control other than autonumber PK is edited or something is typed in it. Which is also nornaly the case in autonumber primary key or anyother primary key control.

I would appreciate if anyone can kindly help. I am in the last stages of this project. It was working fine but i dont know whats gone wrong.

Thank you in advance for your help.

 

[theDBguy]

Hi. Sounds like the form is getting dirty right away. Do you have any code assigning any value to a control on the form? That could cause the form to get dirty.

 

[asadkhan]

Hi. Sounds like the form is getting dirty right away. Do you have any code assigning any value to a control on the form? That could cause the form to get dirty.

There's plenty of code there but nothing which assigns value to any control.

 

[smig]

There's plenty of code there but nothing which assigns value to any control.

You probably either assign a value to one of the fields by code or by a default value on the form.

 

[asadkhan]

Thanks for all advice
Yes it was something very stupid I have done, I redisgned the form going one code at a time and found the culprit. Removed it and it working fine.
Thanks ever so much.

 

[theDBguy]

Thanks for all advice
Yes it was something very stupid I have done, I redisgned the form going one code at a time and found the culprit. Removed it and it working fine.
Thanks ever so much.

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.

 

[asadkhan]

Thanks it's a very good project, I work for NHS.