In Query "match projectID in table to project ID in form'

[arunakumari02]

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]

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)