Index orPrimary key cannot contain a null value error #3058

[Guest]

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?

 

[John Vinson]

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?

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]

 

[Guest]

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.

 

[John Vinson]

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.

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]

 

[Guest]

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?

 

[John Vinson]

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?

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]