VB Forum / Database Access / September 2004

I would like to thank all the people that has helped me in solving my
problems with a list view....
I found it out where my problem was....

It was in the string....

strSQL = "SELECT nome, anno, titolo FROM Dischi WHERE nome LIKE '*" & Text1
& "*'"

even if it seems correct to my eyes....
Infact changing

strSQL = "SELECT nome, anno, titolo  FROM Dischi WHERE nome LIKE '" & Text1
& "'"

it works....

But now how can I find out records filling the textbox with only partial
input
With the first string I can't extract any records even if I write exactly
the record name in the textbox....
Do you know why??????