E
Export Girl
Would like some ideas.
I am creating a form to build quotes for customers. I have a "Quote" table
(quote number, price, quoted by, etc.) and a products table (UPC, units,
SSP, etc.). My main form has the quote information and a subform for
products to quote is in form of a datasheet. In my subform, I have a combo
box that displays all UPC's in the product table. In my "afterupdate" event,
I put code to populate all relevant information to the product. All
information populates correctly. However, when I try to move on (select
another product ont he next line or save the record) I get an error message
stating that Index or Primary Key can not contain a null value. When I look
at my tables, the only table that has a primary key is the products table.
That primary key is the UPC, which I have selected in the combo box.
Any ideas?
I am creating a form to build quotes for customers. I have a "Quote" table
(quote number, price, quoted by, etc.) and a products table (UPC, units,
SSP, etc.). My main form has the quote information and a subform for
products to quote is in form of a datasheet. In my subform, I have a combo
box that displays all UPC's in the product table. In my "afterupdate" event,
I put code to populate all relevant information to the product. All
information populates correctly. However, when I try to move on (select
another product ont he next line or save the record) I get an error message
stating that Index or Primary Key can not contain a null value. When I look
at my tables, the only table that has a primary key is the products table.
That primary key is the UPC, which I have selected in the combo box.
Any ideas?