Assuming that there is no error regarding the variable names or types, can someone tell me whats wrong with this statement?

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

The error says "missing semi-colon", so I am guessing its a problem where I have tried to append the query string and the variables but I cant see it.

Any ideas