str= "select * from 表 where ID='" & Trim$(Text1.Text) & "' and address like '人民路%'"
lrRec.Open str, gdbConn, adOpenKeyset, adLockOptimistic
If lrRec.RecordCount <> 0 Then
MsgBox "此用户合法!",vbOKOnly, "友情提示"
else
MsgBox "此用户不合法!或者还没有注册",vbOKOnly, "友情提示"
end if
lrRec.Open str, gdbConn, adOpenKeyset, adLockOptimistic
If lrRec.RecordCount <> 0 Then
MsgBox "此用户合法!",vbOKOnly, "友情提示"
else
MsgBox "此用户不合法!或者还没有注册",vbOKOnly, "友情提示"
end if