Private Sub cmdSearch_Click()
rsData.MoveFirst
Do While Not rsData.EOF
If LCase(rsData.Fields(0).Value) = LCase(txtSearchFor.Text) Then
txtName.Text = rsData.Fields(0).Value
txtPhone.Text = rsData.Fields(1).Value
txtHome.Text = rsData.Fields(2).Value
If rsData.Fields(3).Value = True Then
chkWorking.Value = Checked
Else
chkWorking.Value = Unchecked
End If
Exit Sub
End If
rsData.MoveNext
Loop
lblEditStatus.Caption = "Status: Not Found..."
查询的代码是这样的,要怎么改呀
Private Sub cmdSearch_Click()
rsData.MoveFirst
Do While Not rsData.EOF
If LCase(rsData.Fields(0).Value) = LCase(txtSearchFor.Text) Then
txtName.Text = rsData.Fields(0).Value
txtPhone.Text = rsData.Fields(1).Value
txtHome.Text = rsData.Fields(2).Value
If rsData.Fields(3).Value = True Then
chkWorking.Value = Checked
Else
chkWorking.Value = Unchecked
End If
Exit Sub
End If
rsData.MoveNext
Loop
lblEditStatus.Caption = "Status: Not Found..."