"All" criteria in a list box

[ekta]

Hi:

I want to know if "All" criteria can be added to a listbox. Right now if users don't make any selection in a listbox it returns all the records. But users want to add "All" criteria in a list box to that. I know it can be done in a combo box. I searched on the forums but did not see it for list boxes.

Thanks,

Ekta

 

[Rich]

The code's the same for combos and listboxes

 

[ekta]

Thanks

 

[ekta]

Rich:

This is what I have so far. But I am having trouble making the "All" criteria work.

I am attaching the db. If you can please take a look at it.

Thanks,

Ekta

 

[WayneRyan]

Ekta,

Here's a sample that I had. I think it's from a post here quite
a while ago.

Wayne

 

[ekta]

Hi Wayne:

Thanx for the sample. That is what I want to do. But I am having trouble adding the "All" criteria in my code. My code loops through multiple listboxes and then builds the where clause.

-Ekta

 

[WayneRyan]

Ekta,

Look at the code behind the "Query" button. That's what
it does.

It will build the SQL that you need.

Wayne

 

[ekta]

Wayne, I did take a look at the code behind the query button. I tried to incorporate that in my code as my code is a little different because of multiple listboxes but I am having a little trouble with it.

 

[WayneRyan]

Ekta,

Can you post a db?

Wayne

 

[ekta]

Hi Wayne:

I already did. If you scroll up you will see it.

Ekta

 

[ekta]

Thanx for all your help Wayne. I figured it out. It works just fine.