You will get "File 'schd.dbf' does not exist" if the file does not exist in the DEFAULT folder. SET DEFAULT TO will fix this.
Bye
Liam
>Hi Liam: > >I have inserted new code for open see below: > >LPARAMETERS cStatus, nInputYear >IF !Used("SCHD") Then >Use SCHD in 0 >Endif >SELECT ; >Ilspm, ; >Status, ; >Start, ; >Comp, ; >Ssp, ; >Ils_k, ; >Avail, ; >Ship, ; >Hull, ; >Num_Chgs ; >FROM Schd ; >WHERE Status = cStatus AND ; >Val(left(SSP,2)) = nInputYear ; >INTO CURSOR Rptstatus1 ; >ORDER BY 5 > >IF _TALLY > 0 >REPORT FORM Rptstatus1 PREVIEW >ELSE > = MESSAGEBOX ("Sorry, there was no records matching your report criteria."), 0, (" Status Report ") >ENDIF > >Question 1: Should I have an open statement Then Program Error File does not exist.
