窗体中对日期应用筛选无法实现的问题
筛选条件用下面的这行命令可以实现
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 & "# "