在窗口分组用什么控件可以从客户自定义数据表中生成一个目录树 我选择其中的街道居委作为分组查询
查询按钮的代码有没有什么特殊要求
类似以下代码可以吗
Dim Filter As
String
With
e.Form.Controls("cmbProduct")
If .Value IsNot
Nothing
Then
Filter =
"产品 =
'" &
.Value & "'"
End
If
End
With
With
e.Form.Controls("cmbCustomer")
If .Value IsNot
Nothing
Then
If Filter > ""
Then
Filter =
Filter & " And "
End
If
Filter = Filter
& "客户 = '" & .Value
& "'"
End
If
End
With
If Filter > ""
Then
Tables("订单").Filter = Filter
End If