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:
Code:
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.
Code:
CurrentProject.Connection.Execute "UPDATE tblIAQSampleInfo SET Analyst=" & Me.analyst & " WHERE ProjectID=" & Me.projectID