title: How to select other row of data in access database using Visual Basic?
body: <p>I am new to programming so don't be too harsh.</p>
  
  <p>The situation is like this:</p>
  
  <p>I want get the values from access database and return it to a textbox in visual basic. I tried these codes but the problem is, it is always returning the data in the first row only. I want to get the data from ID = 4. This is my code:</p>
  
  <pre><code>Private Sub cmdshow_Click()
  
      strsql1 = "select * from Table1 where ID = '4' "
  
      With RS
  
      txtstudent.Text = !Student
      txtage.Text = !Age
  
     End With
  
  End Sub
  </code></pre>
  
  <p>The access database is like this: </p>
  
  <p><a href="http://postimg.org/image/mrtcmsc3b/" rel="nofollow">http://postimg.org/image/mrtcmsc3b/</a></p>
  
  <p>I know that my codes are wrong. The only thing that I know is that I must return the value from database and assign it to a variable and place it in the textbox. I know how the program goes but I dont know the right codes that will work.</p>
  
  <p>Your response will be fully appreciated. Thank you.</p>