Thanks in advance:

I realized that logically I was incorrect. Below is where I attempted to correct my mistake. Now I get: "Incorrect syntax near 'Code'".

INSERT into tbl_Assembly_Delay(ID, Code, DelayTime)

( '#Trim(FORM.Code)#',

'#Trim(FORM.DelayTime)#', SELECT ID

FROM tbl_Assembly_Production

WHERE tbl_Assembly_Production.WorkOrder = '#FORM.WorkOrder#');