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]

Re: Criteria

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 <jonnymenthol@y ahoo.com> wrote in message
news:14f4e726.0 406180610.62640 053@posting.goo gle.com...[color=blue]
> 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.[/color]