> I need to filter the dates in my table according to shipdate field and display that data in a form. This is the code I have done so far to test the situation.( table is open in current work area)


Jeana,

Instead of filtering your table, how about creating a sql select?

I'm thinking something along the lines of....

select * from MyTable ;
  into cursor cMyTable ;
  where dtos(MyDate) = '20031222' ;
  order by MyDate

On your form, place a grid object and specify the RecordSourceType = 4 (SQL statement) and type the above select into the RecordSource property.

Hope this helps.

Jason