<-----code start here--->
Private Sub btnSearchRec_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearchRec.Click

myConnection.Open()
Dim myExpertSearch As New ExpertSearch
' this is the part troubling me...:(
If myExpertSearch.Execute("Select * from stock", myConnection, 0) = True Then
txtSTOCK_ID.Text = myExpertSearch.FieldValue
End If
myConnection.Close()

End Sub
<-----code end here--->

Here is the situation, I wrote a simple stock control program, yet add function was fine... one thing is the search function where the search function have to be done before update or delete it right?

however, I need help on the blue text part where I need to return all the value from search form, yet eventually I'm able to return one value from one column only... if I put a nested if statement... i have to click 10 times of "ok" in term of all the value can reinsert in to the form where I do all the update and delete function... any clue? or tips... I'm suffering here....