Index orPrimary key cannot contain a null value error #3058

Index orPrimary key cannot contain a null value error #3058

Post by Q1JfQ29sbG » Sat, 07 Jan 2006 14:11:02


I have a combo box w/ a select list, but when I select one Access gives me
this error, what is the correct way to fix this?
 
 
 

Index orPrimary key cannot contain a null value error #3058

Post by John Vinso » Sat, 07 Jan 2006 14:51:07

On Thu, 5 Jan 2006 21:11:02 -0800, "CR_Collins"



Make sure that you're putting a non-NULL value into whatever control
is bound to the Primary Key of the table you're trying to update.

Without knowing anything whatsoever about your table, your form, or
your combo box, it's a mite difficult to be specific...

John W. Vinson[MVP]

 
 
 

Index orPrimary key cannot contain a null value error #3058

Post by Q1JfQ29sbG » Sat, 07 Jan 2006 15:03:01

I have two columns that loaded info into them...one is a product id number
w/lettersand the second has the product description....the product id is the
primary key and it has the product id numbers that I want the order form to
go by.
 
 
 

Index orPrimary key cannot contain a null value error #3058

Post by John Vinso » Sun, 08 Jan 2006 02:32:08

On Thu, 5 Jan 2006 22:03:01 -0800, "CR_Collins"



I don't think the error is coming from the Combo Box - I presume it's
storing data into the ProductID field in your Order form, right? (Note
that I *did* ask for information about the tables and forms you are
using, and you chose not to provide that information, so I'm still
guessing in the dark here).

I think the error is arising because your form is not putting anything
into the Primary Key field of the Orders table (or OrderDetails table,
or whatever table the form is trying to update).

You're looking in the wrong place, in other words - the combo is
probably fine. It's something else.

John W. Vinson[MVP]
 
 
 

Index orPrimary key cannot contain a null value error #3058

Post by Q1JfQ29sbG » Wed, 11 Jan 2006 14:30:02

John, I found the problem..when I uploaded the product description I uploaded
number and symbols..is there a way to get the form to accept them?
 
 
 

Index orPrimary key cannot contain a null value error #3058

Post by John Vinso » Thu, 12 Jan 2006 03:22:10

On Mon, 9 Jan 2006 21:30:02 -0800, "CR_Collins"



I have absolutely no idea how your form, your combo box, your uploads,
or your table are structured, so all I can say is "I imagine so, if
you design things correctly".


John W. Vinson[MVP]