thank you,it works,but i need to use this code to get data and i want to add new records,i mean can i add and modify at mygrid via myform.one form.

ENDIF
thisform.Grid1.RecordSource = NULL
SELECT  * FROM TABLE1 where mac1=thisform.text1.value INTO CURSOR grdCursor
thisform.Grid1.RecordSource = "grdCursor"&&&
*thisform.Grid1.Refresh()

>

>thisform.Grid1.RecordSource = NULL
>SELECT MAX(DAT) FROM TABLE1 where mac1=thisform.text1.value INTO CURSOR grdCursor
>thisform.Grid1.RecordSource = "grdCursor"
>thisform.Grid1.Refresh()
>