CurrentProject.Connection.Execute Run-Time Error

[darkwind]

I'm having an issue where the code line to follow is giving me the error "Run-time error '-2147217904 (80040e10)': no value given for one or more required parameters." This line is intended to set the microscope # for all samples in a given project equal to the microscope number given for one of the samples. Here's the code line:

CurrentProject.Connection.Execute "UPDATE tblIAQSampleInfo SET Microscope=" & Me.Microscope & " WHERE ProjectID=" & Me.projectID

There is a text box named, exactly, "Microscope" in the relevent form. tblIAQSampleInfo exists and has a field named, exactly, "Microscope". I've checked, double checked and triple checked these for typos and am confident there isn't one. So really pretty lost on why I would be getting this, especially considering these are the only differences from other similar lines of code, such as the below, which work perfectly.

    CurrentProject.Connection.Execute "UPDATE tblIAQSampleInfo SET Analyst=" & Me.analyst & " WHERE ProjectID=" & Me.projectID

[CJ_London]

is there a value in your microscope control on the form? if so - what is it?

[ranman256]

Docmd.RunSql "update table....."

and if analyst is text,put quotes around it.

[darkwind]

is there a value in your microscope control on the form? if so - what is it?

It has the "Microscope" field from tblIAQSampleInfo as its control source. Its value is currently "PLM1".

[CJ_London]

since this is text you need to add single quotes

...SET Microscope='" & Me.Microscope & "' WHERE...

[darkwind]

Sorry for the late reply, was diverted to a different project for a couple days. Nice catch on that, thanks!