Criteria

[Jonny]

Hello,

I have a list box which displays the date from and date to of each of
my records.

I also on my form, have a date from and date to box at the top. Both
of these are unbound, and are to be used as criteria options. For
example, if I enter 01/05/2004 in the From Date and 01/06/2004 in to
To Date, I only want the list box to display the records between
thesedates.

Can anyone tell me how to do this please ?

Thanks.

[David]

The record source for the list box is a query. In the relevant date field in
the query criteria box you need
something like - Between [Forms]![formname]![fromDate] And
[Forms]![Formname]![toDate]
Then you will need to requery your list box
HTH
David B
Jonny <jo**********@yahoo.com> wrote in message
news:14**************************@posting.google.c om...

Hello,

I have a list box which displays the date from and date to of each of
my records.

I also on my form, have a date from and date to box at the top. Both
of these are unbound, and are to be used as criteria options. For
example, if I enter 01/05/2004 in the From Date and 01/06/2004 in to
To Date, I only want the list box to display the records between
thesedates.

Can anyone tell me how to do this please ?

Thanks.