If you notice, i believe the loop is quite alright. As notice in the early stage where i used text70 to create a table -it can get the name.

First of all when i used LTrim for my text70 Adodc2.Recordset did not select those that are specific under text70 but selected everything.

I think that maybe the problem might be cause by the sentence Data3 as Data3.Refresh can not be refresh and i got the error - incomplete query. As after trying th CLng I still get the right figure.

Anyway thks guys. But do you have any ideas what's wrong with my Data3 and Adodc2-select statement?? Why can't my data3 be refresh??

I really suspect did the adodc2 read my statement as '" & Text70.Text & "' or read as ''. Else it should not select the whole thing??

Pls help.