Hi Freddie,

>Hi:
>
>* Generate a cursor holding report information:
>SELECT ;
> SomeFields ;
> FROM SomeTables ;
> WHERE Ship = THISFORM.txtShipName.Value AND ;
> CompleteDate = THISFORM.txtCompleteDate.Value ;
> INTO CURSOR output ;
> ORDER BY OrderFields
>====================================================================
>Will SomeFields represent all the fields that should show up on the report.
>
>SELECT ;
> Ship , ;
> Hull ,;
> Ssp ,;
> Ilsprm ,;
> Avail ,;
> Msr ,;
> Start ,;
> comp ,;
> Start ,;
> Comp ,;
> Status ;
> FROM schd ;
> WHERE Ship = THISFORM.TxtShipName.Value AND ;
> year(date_field) = THISFORM.TxtCompleteYear.Value ;
> INTO CURSOR Ouput ;
> ORDER BY 1
>
>REPORT FORM MyReport options.... Is this line referencing the actual
>report program itself?
>
>=============================================================================
Notice, please, that I added comma between fields. And instead of schd.dbf you should use just schd as TableName

Make sure, also, that ThisForm.TxtCompleteYear has numeric value (otherwise it would generate an error in this SQL)

REPORT FORM MyReport PREVIEW
MyReport should be replaced with the actual name of your report file (extension .frx).
Look at Help for REPORT command for more details.

HTH