'All' in combo comes up empty

[jkfeagle]

I have a combo box that uses the code from Microsoft Knowledge Base to add 'All' as an option in a combo box. Now that feature works fine. The problem comes in when you use the value selected in the combo box as a criteria for a query. The All option does not work correctly because the criteria would have to be basically ignored in order to return all the records. I have tried trapping the value and substituting a * value, a "" value and a null value but none seem to work. This is particularly confusing because the wildcard * works when used manually in the criteria. All the other selections in the combo box work correctly. Can someone PLEASE help me out here!!!!?????

 

[skwilliams]

Where is your combo box pulling it's values? A value list you typed in, or a another table with the values.

 

[Jack Cowley]

Is the combo box blank after you select All? If so then add this line of code on the line below your current criteria line:

[Forms]![YourFormName]![ComboBoxName] Is Null

hth,
Jack

 

[jkfeagle]

The combo box pulls its values from a stand-alone table. The combo box retains the other values even when All is selected.