Hi Muthu
Maybe not a solution but why not define 2 properties on your form and initialize them with blank dates ={}, rather than doing a CTOD() later in code. Of course set the controlsource of the textboxes to these 2 properties.
Hope it helps.
>I have designed "Report preview.scx" in that i have placed two text boxes namely 1.txtfromdate 2.txtdateto and one command button namely
>"cmdpreviw". I want to preview data between two dates and I have written code below
>
>local lcFrom, lcTo
>lcFrom = ThisForm.TxtFromdate.Value
>lcTo = ThisForm.TxtTdateto.Value
>select * from student;
> where date between CTOD(lcFrom )and CTOD(lcTo);
> order by date;
> into cursor Temp
>Report form "D:\List.frx" preview
>
>For first time I have entered dates in corresponding text boxes and click command button the preview will display, and i have clear the dates in two text boxes again I have entered different dates and click command button the preview will not display.
>
>how to correct my code? or
>Kindly advise me how to write code?
>
>thanking you