Private Sub 查询_Click()

If Combo1.Text = "" And Combo2.Text = "" And Combo3.Text = "" Then
MsgBox ("请输入一个查询依据！")
Combo1.SetFocus
Exit Sub
End If
If Option1(0).Value = False And Option1(1).Value = False And Option1(2).Value = False Then
MsgBox ("请确定一个搜索依据！")
Exit Sub
End If
If Option1(0).Value = True Then
If Not IsNumeric(Combo1.Text) Then
MsgBox ("编号请输入数字！")
Combo1.SetFocus
Exit Sub
End If
Adodc1.RecordSource = "select * from suppliers供应商信息表 where 供应商编号='" & Combo2.Text & "' order by 供应商编号"
Adodc1.Refresh
DataGrid1.Refresh

Exit Sub
End If

If Option1(1).Value Then
Adodc1.RecordSource = "select * from suppliers供应商信息表 where 公司名称='" & Combo2.Text & "' order by 编号"
Adodc1.Refresh
DataGrid1.Refresh
Exit Sub
End If
If Option1(2).Value Then
Adodc1.RecordSource = "select * from suppliers供应商信息表 where 联系人姓名='" & Combo3.Text & "' order by 编号"
Adodc1.Refresh
DataGrid1.Refresh
End If
end sub
提示FROM子语法错误，Adodc1.Refresh不能实现。在线等，帮帮忙啊，急

过来啊，大家过来啊

Private Sub Command1_Click()
If Combo1.Text = "" And Combo2.Text = "" And Combo3.Text = "" Then
MsgBox ("请输入一个查询依据！")
Combo1.SetFocus
Exit Sub
End If
If Option1.Value = False And Option2.Value = False And Option3.Value = False Then
MsgBox ("请确定一个搜索依据！")
Exit Sub
End If
If Option1.Value = True Then
If Not IsNumeric(Combo1.Text) Then
MsgBox ("编号请输入数字！")
Combo1.SetFocus
Exit Sub
End If
Adodc1.Recordset.MoveFirst
Adodc1.Recordset.Find (" 供应商编号 like '" & Combo1.Text & "' ")
If Adodc1.Recordset.EOF Or Adodc1.Recordset.BOF Then

MsgBox "没有找到！"
Else
MsgBox "已经找到！"

DataGrid1.Refresh
End If
Exit Sub
End If

If Option2.Value Then
Adodc1.Recordset.MoveFirst
Adodc1.Recordset.Find (" 公司名称 like '" & Combo2.Text & "' ")
If Adodc1.Recordset.EOF Or Adodc1.Recordset.BOF Then

MsgBox "没有找到！"
Else
MsgBox "已经找到！"

DataGrid1.Refresh
End If
Exit Sub
End If
If Option3.Value Then
Adodc1.Recordset.MoveFirst
Adodc1.Recordset.Find (" 联系人姓名 like '" & Combo3.Text & "' ")
If Adodc1.Recordset.EOF Or Adodc1.Recordset.BOF Then

MsgBox "没有找到！"
Else
MsgBox "已经找到！"

DataGrid1.Refresh
End If

End If
End Sub

学习