Query error

[ZOR]

I have some code which runs okay on a listclick event. I can hold the down arrow whilst having focus on the list, and it passes through all records in the list without error. However if I do the same on a loop, ie setting the listindex value of the list to the loop value, it breaks code on the line below.

If I run my mouse over the STRSQL syntax, I get a highlight message STRSQL = "Insert into Athletes (ID2,NName) Values (7366, ' George Gregan')"

What does it mean?, why does it pass through okay on a manual list pass? Thanks

STRSQL = "Insert Into Athletes (ID2, NName) Values (" & ID2 _
& ",'" & Replace(WD2, "'", "''") & "')"

 

[JerryKlmns]

> it breaks code on the line below.

And says what? Error meassage should be very explanatory to everyone

Maybe you should provide more of your code.