Hi Freddie,

It can't find the table "Schd".

Include the table in the form's Data Environment or include the path to the table eg "from data\Schd" in the SELECT statement.

HTH

Liam




>Hi:
>User input these fields below into form.
>User Input Status: COMPLETE
>
> Input Year: 99
>
>
>User Click On Command Button to EXCUTE Report
>
>then an Open File Windows appears to input file name.
>
>Question 1. How can I keep this from happening?
>Question 2. Should I have a Open and Close command in this program?
>
>LPARAMETERS cStatus, nInputYear
>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