Does anybody know how to go to a specific record in a table using VB?


Here's what i mean

I have a table with ID, INFO, NOTE


ID | INFO | NOTE

----------------

1 | Text1| Text1 row1

2 | Text2| Text2 row2

3 | Text3| Text3 row3

-----------------


what i wanna do is if i entered 2 in a textbox and press enter,

it'll display the "Text2" in a textbox, and "Text2 row2" in another textbox

Any help would be appreciated.


Thank you


Sang