Error in combo box

[rjohnstone1]

I have a purchase order form and when i change a value in a combo box fields change accordingly. My problem is that when i delete info in the combo box and exit it i get a jet database "you cannot assign a null value to a variable that is not a variant data type. I have tried to fix it with no solutions. Any help would be greatly appreciated.

 

[Jack Cowley]

Your combo box is based on a table or a query. You should delete the data from a form based on that table or query and not from the Combo box itself.

I hope that I understood you correctly.

HTH,
Jack

 

[rjohnstone1]

Yes my combo box is based on a query for vendors. When i pick a vendor from the combo box, the vendors address, phone, contact etc. is put into fields on the form. The problem is that when i pick a vendor and then delete all the information in that combo box i get the error when leaving the combo box. The only event i have is on update, after change. Maybe that will clarify my situation.