>First of all, thank you for your assistance. I truly appreciate it!
>
>I've narrowed the problem down to be the space in the field name. If I test my query in the Visual Data manager it works fine with the [Contract #] field name. In VB it works if I change the field name for testing - I cannot change the field name permanently!
>
>In VB though, it will not work for me with the space in the field name. Is there some way around this apparent bug? This field name is no trouble for other queries but it is obviously causing issues with the INSERT.
>
>Any thoughts for me to try?
>
>Thanks again,
>John

See if you can add it through ADO with the AddNew method of the recordset.

As a Hail Mary :), try specifying the fully qualified field name (with table and all) in the insert statement like so: [method2].[contract #]

Other than that I am all out of ideas.