> 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
---------
Single field, surrogate primary keys....because it's sexier!
Third normal form is more than just a good idea.