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.