Primary key cannot contain a null value.

[Chris]

When copying one field in a database to another field, I
get the error "Primary key cannot contain a null value."
I currently have it set to "Yes, not allow duplicates." I
couldn't find the solution on the MS Knowledge base.

 

[Roger Carlson]

By definition, a primary key cannot contain a Null. There is no solution.
You either have to provide a value or remove the primary key designation
from the field.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Michael J. Strickland]

In design view, select the field that is designated primary key and click
the Key icon (clear its primary key status).