Run-time error '3061':
Too few parameters. Expected 2.
I've verified that the query works by running it other ways. I can double-click on it and it fires off just fine, and it plays nice with DoCmd.OpenQuery. I'm trying to get away from DoCmd.OpenQuery because of having to use SetWarnings False/True to make it not ask me if I'm sure I want to update the table when the query runs. I have read several suggestions other places saying to use CurrentDb.Execute instead, but I cannot get it to work. I've tried it without the dbFailOnError, and I've tried these, both with and without dbFailOnError:
I'm not sure if this makes any difference, but the query that's trying to run does pull some date data for SQL comparisons from form fields. I've set the form field types to "General Date". I'm not sure if that's correct since some of them have date/time info (9/6/2008 12:00:00AM) and others just have the date (9/6/2008). I've also tried adding the following to the beginning of the SQL itself to see if that made a difference, but it didn't.