halirui说:
ylm,你的办法很不错,不过——
最简单窗口中的查询按钮的公式太烦琐!
IF([%选项%]="月份",FilterFor("月份"," Instr ",[%订单号码%]),
IF([%选项%]="订单号码",FilterFor("订单编号"," Instr ",[%订单号码%]),
IF([%选项%]="联系人",FilterFor("联系人","Instr",[%订单号码%]),
IF([%选项%]="订货日期",FilterFor("订货日期","Instr",[%订单号码%]),
IF([%选项%]="交货日期",FilterFor("交货日期","Instr",[%订单号码%]),openwindow(4))))))
用一个简单的filterfor([%选项%],“instr”,[%订单号码%])一样可以达到效果!