实现检索功能最重要的是如何获得检索条件: 下面这个函数也许对你的问题有帮助,仅供参考: Private Function GetCondition( _ Byval iobjComboBox As ComboBox, _ Byval iobjTextBox1 As TextBox, _ Byval iobjTextBox2 As TextBox _ ) As String Dim strCondition As String
If iobjComboBox.Text="与" Then 'combobox选择"与",其中,field1、field2是检索的字段名; strCondition = "WHERE field1='" & iobjTextBox1.Text & "' " _ & "AND field2='" & iobjTextBox2.Text & "'" Else 'combobox选择"或" strCondition = "WHERE field1='" & iobjTextBox1.Text & "' " _ & "OR field2='" & iobjTextBox2.Text & "'" End If GetCondition = strCondition End Function 调用时代码如下: Dim strCondition As String ComboBox1.Text="" ComboBox1.AddItem("与") ComboBox1.AddItem("或") TextBox1.Text=field1值 TextBox2.Text=field2值 strCondition = GetCondition( _ ComboBox1, _ TextBox1, _ TextBox2)
下面这个函数也许对你的问题有帮助,仅供参考:
Private Function GetCondition( _
Byval iobjComboBox As ComboBox, _
Byval iobjTextBox1 As TextBox, _
Byval iobjTextBox2 As TextBox _
) As String Dim strCondition As String
If iobjComboBox.Text="与" Then
'combobox选择"与",其中,field1、field2是检索的字段名;
strCondition = "WHERE field1='" & iobjTextBox1.Text & "' " _
& "AND field2='" & iobjTextBox2.Text & "'"
Else
'combobox选择"或"
strCondition = "WHERE field1='" & iobjTextBox1.Text & "' " _
& "OR field2='" & iobjTextBox2.Text & "'"
End If GetCondition = strCondition
End Function 调用时代码如下:
Dim strCondition As String ComboBox1.Text=""
ComboBox1.AddItem("与")
ComboBox1.AddItem("或") TextBox1.Text=field1值
TextBox2.Text=field2值 strCondition = GetCondition( _
ComboBox1, _
TextBox1, _
TextBox2)