I am try to update a single record in a differant table when a record from the edit screen is complete on a related table
Here is the code block
Sub AfterEdit()
'** Custom code ****
strSQLUpdate = "UPDATE (Viability INNER JOIN Production ON Viability.Prod_ID = Production.Prod_id) INNER JOIN Functions ON Viability.Func_ID = Functions.Func_ID SET Viability.Viable = IIf(Production.Prod_Total/Production.time>Functions.Viability_Quota/7.46,1,0), Viability.Emp_ID = Production.Emp_ID, Viability.[Date] = Production.Date, Viability.Quota = Functions.Viability_Quota/7.46, Viability.Hourly_prod = Production.Prod_Total/Production.time, Viability.div_id = Functions.Div_id, Viability.Dept_id = Production.Dept_id WHERE Viability.Prod_id =" & dict("Prod_ID")
dbConnection.Execute strSQLUpdate
End Sub
This statement does not seem to run however it does not give me an error either.
I am new to this feature so I have a feeling it is a basic syntax problem.
I suspect the dict("")
Any help?
Thanks <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=3757&image=1&table=forumtopics' class='bbcemoticon' alt='<<' />
