PDA

View Full Version : In Query "match projectID in table to project ID in form'

arunakumari02
06-09-2008, 02:09 PM
How to match projectID in table to project ID in form

When I run this command I get syntax error

DoCmd.RunSQL "UPDATE tblProjects SET ResourceOptimizer=False where ProjectID = forms!frmPipeline("txtProjectID" &intRow)"
pbaldy
06-09-2008, 02:15 PM
The quotes in the form reference mess up the quotes of the SQL string. Try this:

DoCmd.RunSQL "UPDATE tblProjects SET ResourceOptimizer=False where ProjectID = " & forms!frmPipeline("txtProjectID" & intRow)