I have a form with a combo box that selects a company name from a suppliers table. The address of the company also appears once the name of the supplier has been selected from the list. The combo box is bound to the SupplierID number although that does not appear on the form. Is there anyway to add to the Supplier table if the company is not on the available list. I have done this in a previous form by assigning the dblclick event to a code copied from an Access Wizard database but the syntax I used then is not working this time and I'm getting a msgbox:
"You tried to assign a null value to a variable that is not a variant data type". Not sure what is different about this form and combo box.

Take a look at this article. I think you will find your answer there. http://support.microsoft.com/support/kb/articles/Q161/0/07.asp?LN=EN-US&SD=gn&FR=0

HTH,
Jack

Working great, thanks.

DBL