I have a small VB application with an access database as backend. I amd using ADO connection. It is working fine. Now my requirement is very simple. I have a text box in which if I type some thing, the records beginning with that should be displayed. Initially I was using DAO and I was able to do this. Now I'm trying to use ADO. I don't know how to do this using ADO. Basically I want to change the contents of the recordset at runtime depending upon a different querry. Please help me in this with the command/syntax.
Thanks in advance,