Hi Everyone

For some reason a ComboBox that has the event Not In List is returning this error:-

Runtime error 3134
Syntax Error in INSERT INTO statement

the code breaks at this point:-

CurrentDb.Execute strSQL

Has anyone come across this before?

Mike

Hi Mike
No..
We may need to see more of the code behind the combo event..!!

Hi Larry

I have managed after a bit of digging to find a piece of code provided by Alan in the link below:-

Link

It has all boiled down to a space in the name of the table and is now resolved

Thansk for your trouble

Mike