You tried to assign the Null value to a variable that is not a Variant data type.

Are you sending all the values for all the columns in the Insert query?

Also, check the DB table if there is any column which is not null.

HTH,

Vivek

Hi Vivek,

All the table values are being sent in the InsertCommand with the exception of the autonumber field (Bulletin_ID). If you look at the InsertCommand, the only field that isn't required isMessage, but I'm sending that value as well so it should be ok.

Many Thanks,

Mark

Hi Vivek,

This is working. I had two different versions of the same form and didn't realize my page was loading the older version. Sorry to all for the confusion. Thanks for the help!

Mark