数据库表中有发票起号和发票止号两项，输入中间号码查询信息，以下是我写的“查询”click代码，但执行以后查不出来，麻烦大侠们帮忙修改一下，谢谢
t1=alltrim(thisform.text1.value)
t1=val(t1)
loca for t1>=val(发票起号) and t1<=val(发票止号)
if found()
  sele * from 发票信息 where t1>=val(发票起号) and t1<=val(发票止号) into cursor "temp"
  thisform.grid1.recordsource="temp"
 else
  messagebox("未找到相关记录！",64,"提示")
endif

改成下面的方式试试:
t1=val(thisform.text1.value)
sele * from 发票信息 where val(发票起号)>=t1 and val(发票止号)<=t1 into cursor "temp"
if _tally=0
  messagebox("未找到相关记录！",64,"提示")
else
  thisform.grid1.recordsource="temp"
  thisForm.refresh
endif

t1=val(thisform.text1.value)
sele * from 发票信息 where BETWEEN(T1,val(发票起号),val(发票止号) into cursor temp
IF RECCOUNT()>0
    MESSAGEBOX("未找到相关记录！",64,"提示")
ELSE
    thisform.grid1.RecordSourceType = 4
    thisform.grid1.RecordSource = "temp"
    thisForm.refresh
ENDIF