In Dreamweaver Ultrdev 4, I have created a DSN connection
to an Access Database. I am able to retrieve records based
on specific regions. My question is can I create an "Insert form"
and using the first data field labeled "ID" trigger an autonumber
(like access does) in my "Insert form". If I can't is there another
way to produce the same results?

After consulting with several forum the consensus seems to be that I
do not need to create an autonumber for my "Insert Record Form" The user
does not need to see or fill out that information. However, when
I take that field out of my Insert Record Form I get the following 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.

/UCSDEV/PBX/ASPCode/TMPih4jdqono.asp, line 90


Help!