Hi All,

I posted my question before.But i want to make sure i am posting again same question.
I want to filter the table that start letter with "T"(Both cases).Below is the query i used in VB.
strSQL = "SELECT * FROM SubCont WHERE Sub_Cont_Name LIKE '" & "T" & "*'"
I tested in my Access Query it giving results.
But when i used in VB,I am getting the recordset.EOF = true.
So what is the option i have to use to get the correct recordset.

Thanks,
CM