What am I doing wrong in the following line of VBA.
DoCmd.RunSQL "update [job reports] set PLANT = " & DLookup("[plant]", "[EquipmentList]", "[No]=forms!navigationform!navigationform!jrsub!equipref") & " where [Job Number ID] =Forms![NavigationForm]![NavigationForm]![Job Number ID] "
I have this in an Afterupdate event on a form. When I run it it asks for parameter value.
Your help would be gratefully received.