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?
>