Filtering Form

[vanny]

Hi all,

I have a form where the user can input the Year and Market and the corresponding Orders for that particular year will show up. (acting like a filter)

How can I link the Year with the Order Date? so that only orders related to that particular year will show up!!

In the Orders Table there is a field called ODATE = dd/mm/yy


Any suggestions will be appreciated.

Thanks a lot.

 

[MStef]

Look at "DemoFilterYearDateA2000.mdb".
Try Form1 and Form1Q.

 

[vanny]

Thanks a lot for your help MStef, i applied some of the example's feature to my program and it successfully worked.

Thanks a lot.