Hello Glen,

The 4 variables to be inserted are Strings but the variable in the WHERE statement is an Integer. So I tried:

query = "INSERT INTO [Assign Hardware] ([Base Unit ID],[Monitor ID],[Keyboard ID],[Printer ID]) VALUES ('" & bid & "','" & mid & "','" & kid & "','" & pid & "') WHERE [Employee ID] = " & eid & ";"

Alas, the same error.