Try:

.RecordSource = lcSource

>I am using the following code to get the data and display in grid with button click event:
>But nothing is happening, Can you please tell me do i have to do change any properties of the grid before i do the button click:
>
>######################################################################
>lcSource = "select distinct(a.tiffile), b.docindex_i from ocrdata a, docudeck b ;
>where a.tiffile = b.file_name ;
>And a.OCDATA like '% + alltrim(thisform.text5.value)+%' ;
>Order By a.ID into Cursor lcSource"
>
>
>with thisform.grid1
>.RecordSource = ""
>.RecordSourceType = 4 && SQL
>.RecordSource = "lcSource"
>endwith
>######################################################################
>
>Please let me know, Thank you very much.