multiselect listbox and date range (1 Viewer)

[m kappler]

I attach an MDB that the has the multiselect listbox
control. I would however, like to include on the same form
a criteria for a date range; start date, end date and then
build that into the sql when I run the query.
I woiuld also like to make the "All" stay at the top of the
list box.

Can anyone please help me on these 2 items.

Many thanks

 

[edtab]

You can replace "All" with " All". This will keep it at the top
of your list. You also need to change the code for your "strWhere"
to reflect " All" instead of "All"

As far as the date parameter is concerned, you need to modify your
criteria to include a second condition for the beginning and ending
dates found on your text boxes.

Extend "strWhere" to include something like this:

& "AND YourdDateField Between " & forms!YourFormName!BeginDate & "AND "
& forms!yourformnameEnddate;