Error Message "Index or Primary Key cannot contain a null value"

Error Message "Index or Primary Key cannot contain a null value"

Post by ZZBC » Wed, 22 Aug 2007 23:48:39


I am using Access 2000 and XP and attempting to append a record in VB6.
The statement:
Adodc1.Recordset.Update
is giving me an error message:
Index or Primary Key cannot contain a null value
I had originally initially had one indexed field "RecNO" but changed it
to a non indexed database in an effort to troubleshoot my code.
I am still getting the error message.
Suggestions Please?