窗体中对日期应用筛选无法实现的问题
筛选条件用下面的这行命令可以实现
  Filter   =   "[日期]   between   #   2007-6-1#   and   #   2007-9-10   # "
但是用下面的命令行却有问题
Filter   =   "[日期]   between   #   text22   #   and   #   text24   #   "
现在已经在调试状态可以看到text22=2007-6-1且text24=2007-9-10。text22是在窗体中设的文本框的名称，格式为“常规日期”。
此问题困扰了我好几天，请帮忙

------解决方案--------------------

--文本框名需要在串外面，通过&连接到串中

Filter = "[日期] between # " & text22 & "# and # " & text24 & "# "

------解决方案--------------------
Filter = "[日期] between # " & text22 & "# and # " & text24 & "# "