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]