Filtering by Dates "Andy Roberts" <andy[ at ]blue-bean.co.uk> 12/31/2008 12:37:12 PM I have a form which lists all my projects from day dot (all with dates stores as dd/mm/yyyy). When I open the form I want either cbo boxes or radio butoons which when used will filter the form by a date range. e.g. I would like to select the year from the first cbo, then the month from the second combo then the day from the third cbo and the continuous form will sort automatically as each cbo is selected. -- Regards Andy ___________ Andy Roberts Win XP Pro Access 2007 Liverpool, UK

RE: Filtering by Dates Dorian 12/31/2008 10:41:01 PM And what is your question? -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "Andy Roberts" wrote: [Quoted Text] > I have a form which lists all my projects from day dot (all with dates > stores as dd/mm/yyyy). When I open the form I want either cbo boxes or > radio butoons which when used will filter the form by a date range. > > e.g. I would like to select the year from the first cbo, then the month from > the second combo then the day from the third cbo and the continuous form > will sort automatically as each cbo is selected. > > -- > Regards > > Andy > ___________ > Andy Roberts > Win XP Pro > Access 2007 > Liverpool, UK > > >