I made another change and I get this: Incorrect syntax near ','.

INSERT into tbl_Assembly_Delay(ID, Code, DelayTime)

SELECT ID

FROM tbl_Assembly_Production

WHERE tbl_Assembly_Production.WorkOrder = '#FORM.WorkOrder#' AND ('#Trim(FORM.Code)#' ,

'#Trim(FORM.DelayTime)#');