TROUBLE UPDATING MULTIPLE TABLES WITH

Mark1932 So many things to address.

For starters why do you want to use an unbound form in the first place? Access is unique among development tools in its ability to use bound forms. Why not take advantage of that power? I'm not saying there are no situations where unbound forms are reasonable, only that they are rare.

We try, as professional developers, to follow good design principles. Another one is that we do NOT try to update data in multiple tables simultaneously in a single form. If you have tables in a one-to-many relationship and want to add or update data in both the parent (one-side table) and the child (many-side table), the preferred design is a main form/sub form. The one-side table is bound to the main form and the many-side table is bound to the subform. Data must be added first to the table bound to the main form, then it can be added to the table bound to the subform.

It's possible to deviate from that standard design, but there ought to be a powerful reason to justify it.

Finally, your posted SQL looks like it has table and field names with spaces in them, e.g. Participant Registration List or Employee ID Number.

If that is accurate, you must delimit all of those names with square brackets, e.g. [Participant Registration List] and [Employee ID Number].

However, a much better approach is not to use spaces or other special characters in table and field names at all to head off this complication, e.g. ParticipantRegistrationList, or EmployeeIDNumber.