Combo box

[tlaksh]

I have a query that has a where clause & get its value from a combo box. I want it to show all records if nothing is selected in the combo box

How can i achieve this? Please help.

Thanks
Lakshmi.

 

[SteveR77]

Lakshmi,


In the where clause where you have the reference to the combo box control add an &"*" this will allow you to pass the wildcard for everything when nothing is selected but limit the list to what you select in the combo box otherwise.

Steve

 

[tlaksh]

I tried that but it does not seem to work. I am adding it in the query's cliteria along with

[Forms]![Parameter_queries]![Combo1] & "*"

but it still does not show records for all the options in the combo box

Thanks
Lakshmi.

 

[DeanWilliams]

Hi,

You can check the value of the ComboBox and if it is null or "", [Nz(ComboBox1) = ""] then
change the WHERE clause to a value that is always True.

If Nz(ComboBox1) = "" Then
strSQLWhere = "[IDField]=" & IDField
Else
....
End If

You can start with that,

Dean

 

[SteveR77]

Lakshmi,

Apologies you will need the LIKE statement at the beginning of your criteria as well.

 

[tlaksh]

Thanks Steve ..it worked

Lakshmi.

 

[tlaksh]

The statement works with Like but then when a combo item is chosen it also includes anything that looks like this item. for eg. if the combo item chosen is 16 and we have say 167 in the table it displays result for both.

Thanks
Lakshmi.