VBA & SQL error

[PaddyIrishMan]

Oops

Example attached

 

[nebon]

Thank you !

thank you guys fizzio and PaddyIrishMan ...
everything is workin now, thnks to you guys , thanks again , and again ! )

 

[Fizzio]

No probs, glad you got there in the end. A lot of the difficulty was my assumtion that the ID was a long integer, and never considered it may be a string. Your initial problem was probably solved by Dimming intShow_Id as strShowID instead and the probs you have had since may have been averted.