I have a small Access database and I created a form to insert new records into
it, but when I attempt, I get an error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] You tried to assign the Null value
to a variable that is not a Variant data type.

/Corporate/Complaints/forms/insert.asp, line 78

I understand this has to do with the autonumber in the database, since it is
the primary key. Any help will be greatly appreciated.:confused;