When entering data in a form, the value in my primary key changes

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

Guest

This is my first database.

My primary key that links the table is a number.

When I am entering data, the primary key field changes to "0".

I changed the properties of the primary key to no default, but I still have
this problem.

Any help would be appreciated.
thanks.
 
Hi Donna,

For your immediate needs, go into your table design, and change the datatype
from "number" to "Autonumber". This will solve your default value issue.

Brian
 

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

Linked Forms Unlike Form/Subforms in Not Passing Primary Key Value 8
Restrict entering Null or Empty in Textbox - Access 2007 0
Auto-populate a form 4
Primary key changed to Zero in table 1
missing records in form 1
Access 2010 Form Issue's 0
Entering data with many to many relationship 1
form setup 5

Back
Top