hello guys and happy new year!~
let me be the first to ask a question this 2015.. huehue
is it possible to start with the same recordset when going to the next form?
i have a textbox for name in form1 when i go to form2 i want to display in the label his address.
sample database
name-------address
abc--------123
def--------456
ghi--------789
let's say im on recordset 2.. i type on my textbox "def"
then go to next form and the label should display "456"
my code is missing something
Private Sub Command1_Click()
Adodc1.Refresh
Do Until Adodc1.Recordset.EOF
If Adodc1.Recordset.Fields("name") = Text1.Text Then
[missing code]
Form2.Show
Exit Sub
Else
Adodc1.Recordset.MoveNext
End If
Exit Sub
Loop
End Sub
or if you can suggest other code..
thanks!~