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.