By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,607 Members | 1,788 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,607 IT Pros & Developers. It's quick & easy.

Criteria

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.