Dear Sir,

I am using VFP6. On a form I have a grid and two date type textboxes.

The grid has following properties

thisform.grid1.recordsource="stock"
thisform.grid1.column1.controlsource="stock.date"
thisform.grid1.column2.controlsource="stock.amount"

The stock table has data from 01/01/2003 to 31/12/2003.
Is it possible to display data, in grid, from 25/02/2003 to 30/11/2003.
The text boxes are for entering dates.

For some reasons I do not want to use another temporary table for grid's recordsource. I want to use stock table as recordsource.

Plese help