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

D

Donna

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.
 
B

Brian Bastl

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
 
Top