I have a Listbox that filters my recordset by code e.g. FF, CL. The problem I have is that in the list box I want the user to be able to select 'ALL' to display all the records with all the different code from the dropdown. I'm sure I have have just passed '%' as the value before and this just brings up all the field but its not working.
Does this only work with number fields?
My URL string:
<select name="code" id="code">