Problem with Advanced Append Query

[Robnauticus]

Hello all nice to see you again,

I am having a problem creating an append query to populate multiple records from input on a form. The field on the form is a date field.

To sum it up, the user will type in the date and click the commit button that runs the query. The query will take that date and create a record for each task in a list (separate table).

I created an 3 expressions that point to the fields on the form to append to the key fields and date field in the completed tasks table.

PARAMETERS Forms![NewJobSetup]![JDE Number] Long, Forms![NewJobSetup]![JDE Division Code] Text ( 255 ), Forms![NewJobSetup]![DateCommitted] DateTime;

INSERT INTO CompletionLog ( [JDE Number], [JDE Division Code], TaskName, DateComplete )

SELECT [Forms]![NewJobSetup]![JDE Number] AS Expr1, [Forms]![NewJobSetup]![JDE Division Code] AS Expr2, [MasterTaskList]![ID] AS Expr3, [Forms]![NewJobSetup]![DateCommitted] AS Expr4

FROM MasterTaskList INNER JOIN (JobTable INNER JOIN CompletionLog ON (JobTable.[JDE Number] = CompletionLog.[JDE Number]) AND (JobTable.[JDE Division Code] = CompletionLog.[JDE Division Code])) ON MasterTaskList.ID = CompletionLog.TaskName;

Please feel free to take a look at the DB I have attached to see what I am trying to do.



Any leads on where to check for problems would be appreciated.

Thanks
Rob