Crazy Error That's NOT An Error!

[Mavila]

I'm using VBA to insert a record into an Access DB. I'm getting an error:

"Run-Time error: '-2147217900 (80040e14)':

The INSERT INTO statement contains the following unknown field name: 'Test'. Make sure you have type the name correctly, and try the operation again."

I've tinkering with this for 30 minutes now. I know it's typed correctly in both the DB table and the INSERT statement. Does anyone know another potential cause for this?

[Mavila]

Is it possible that a reference, or lack thereof, could cause this? I can't find the Microsoft Windows Common Controls 6.0 (SP 6) on the references list. I've used it before on this machine for other project, but I can't see it now. I have a datatimepicker control on the user form.

[Mavila]

OK, I stripped this rather long INSERT statement down to one parameter and it sort of works, so I will just add them one at a time and see where I get with that method.