Hi,
I am using a combobox as a dropdown list in order to establish some filtering through SQL statements. In other words if I choose "option 1" from the list I shall see only those records containing "option 1" in the corresponding field of another listbox used for display. RowSourceType is "3-SQL Statement" and I am selecting 2 columns: a description field and the indexed field used for filtering. Everything works great up to this point, but if I want to disable filtering I use a checkbox that says "All Records". What is really happening here is that the memory variable used to hold the value returned by the combobox is forced to be Null, thus the condition (in SQL statement of the listbox) WHERE field = variable is always true for all the records, giving as a result: NO FILTERING. This also works fine.
My question is: How can I achieve the same results without having to use a checkbox and including the option "ALL RECORDS" in the combobox list ?
Thanks in Advanced or Hope This Helps