hi,
thank you so much,
myfield DAT have date as 28/02/2005
i need to get all data from my table to mygrid where mac1=thisform.text1.value and DAT=month+year(thisform.text2.value),
and after that i can add new record via e.i text3,text4,text5,text6,text7,text8 .at text8 i put mycode as append blank
thanks.


>Mohhamed if I don't know the structure of Table1 I can't help You. May be something like this:
>
>

>thisform.Grid1.RecordSource = NULL
>SELECT * FROM TABLE1 WHERE mac1=thisform.text1.value .AND. Table1.nMonth == 1 ORDER BY Table1.nDay INTO CURSOR grdCursor READWRITE
>mntLastDay = DATE(grdCursor.nYear, grdCursor.nMonth, 1)
>mntLastDay = (GOMONTH(mntLastDay,1) - mntLastDay)
>SELECT grdCursor
>FOR nDay = grdCursor.nDay+1 TO mntLastDay
>    INSERT INTO grdCursor (nDay) VALUES (nDay)
>NEXT
>thisform.Grid1.RecordSource = "grdCursor"
>thisform.Grid1.Refresh()
>