Put search result into a variable

Hi there,
I have read a thread by arnax asking a similar question but there is no reply yet, so I have created this thread.
Below is my code:

DataControl.RecordSource = "select * from TestAnsBank where TestId=2 AND TestNo= " & numArr(textBoxIndex) & ""

How do I put the searched text into a variable? Thanks a lot! :)

You can use DAO or ADO to create recordset objects which can be filled by sql statements.

have a look here for to find some tutorials
http://www.visualbasicforum.com/showthread.php?t=39722

malloc

Thanks for the prompt reply!

Hi there,

Besides using ADO or DAO, is there a way to put the searched text into a variable?

Since I have always used the basic database command like Recordset and SQL and I have time limitations, I find it hard to learn ADO or DAO. Below is my code:

DataControl.RecordSource = "select * from TestAnsBank where TestId=2 AND TestNo= " & numArr(textBoxIndex) & ""

Can anybody help? Thanks! :)

myVar = DataControl.Recordset.Fields("FieldName").Value

Hi Reboot, It was so silly of me of not knowing the code...rather, it did not cross my mind of using it at the first place....thanks a lot! :D