Hi Kiran,
First put the values fetched to cursor like this
SELECT * from unfixeddealsregister WHERE customercd = vcustomercd into cursor CursResult
thisform.grid1.recordsource="CursResult"
then set individual columns
I hope this works.
Aashish
>I have a field customer code which is a user input text box. When the user inputs the text box - and clicks on refresh.
>
>The grid should fetch results based on the following criteria
>
>All code written against the Refresh button
>
>vcustomercd=ALLTRIM(thisform.Text1.text)
>** This is where the customer code gets captured
>
>WAIT WINDOW "Customer Code is "+vcustomercd
>** Displaying the customer code
>
>SELECT * from unfixeddealsregister WHERE customercd = vcustomercd
>** The Output of this should be directed to the grid which is associated with the table unfixeddealsregister
>
>Pls suggest a way out !
>
>Thx & Rgds,
>
>KB.