Hello Ria
at the end of your sql you must put a "into" or a browse window will be displaied
i.e.
select * ;
from table ;
where a = 'A' ;
into cursor TmpCursor
>My program uses a grid control to display the data.
>The RecordSourceType = SQL statement
> RecordSource = select field1,field2 from mytable
>
>When this from is displayed, the results of this query is displayed over the entire from. To view my from, I have to close this. My grid shows only the selected fields. Could someone tell me why the query results are displayed?
>
>Thank you.
>
>Ria