使用组合框通过VBA在子形式表中搜索名称

Question

我正在尝试使用组合框从父级的subform上进行搜索过滤器，我已经设法进行了搜索日期，我试图根据一个客户名称现在...我有，但是它不起作用...

    Me.subform.Form.Filter = "[Client]=& me.cboClientName&"

我设法通过这样的日期指令进行搜索。

    Me.subform.Form.Filter = "[AppointDate]=#" & Format(Me.cbSelectDate, "yyyy-mm-dd") & "#"

Answer 1

您必须将字符串与已搜索的列和组合的值限制，并且必须应用过滤器。

Dim strFilter as string
'first print what you did
strFilter =  "[Client]=& me.cboClientName&"
Debug.Print "Your faulty filter: " & strFilter ' shown in immediate window
'now with concat
strFilter = "[Client]= '" & Me.cboClientName & "'" ' suround by quotes because I assume it's a string
Debug.Print "filter: " & strFilter
Me.subform.Form.Filter = strFilter
Me.subform.Form.FilterOn = true ' activate the Filter