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.
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..
Edited 1 Year Ago by Reverend Jim: fixed formatting