Dim rst As ADODB.Recordset
Dim strAsk As String
Set rst = Me.Recordset
strAsk = InputBox("请输入供应商ID", "搜索")
If strAsk <> "" Then
rst.MoveFirst
rst.Find "Supplier Like '%" & strAsk & "%'"
Me.Recordset.Find "Supplier Like '%" & strAsk & "%'"
If rst.EOF Then
MsgBox "未找到此供应商!", vbExclamation + vbOKOnly
End If
End If