Have you tried debugging it?, step through it, and check the resulting where expression. What about the lcMajor, variable?, when is a value assigned to it?, have you checked that it has the expected value before executing the query?.

>Hi Jorge,
>I have it narrowed down to a select statement that works the second time, and thereafter, just not the first time.
>
>

>SELECT Iordterm.psnum, Iordterm.custcode, Iordterm.customer, ;
>  Iordterm.project, Iordterm.statesold, Iordnum.psnum, ;
>  Iordnum.shipdate, Iordnum.plslb, Iordnum.bulklb, ;
>  Iordnum.extended , Iordnum.bulkcost, Iordnum.lotnum, ;
>  Iordnum.bulkprice, Iordnum.lotlett, Iordnum.variety, ;
>  Iordnum.salesman, Iordterm.ordtot ;
> FROM  sis!iordterm INNER JOIN sis!iordnum ;
>   ON  Iordterm.psnum = Iordnum.psnum ;
> WHERE BETWEEN(Iordnum.shipdate,ldBegDate, ldEndDate) ;
> AND !DELETED() AND &lcMajor ;
> into table combotemp
>
>

>
>>Hi Winn, do you refresh the form when the button is clicked?, could you post the code in the button's click method?
>>