Question
How to create a search all value on list
I am trying to create a form which will enable user to select
an item on a list to filter records, or allow him to not select
anything and see all records.
I created a generic form with one list on it and a submit button. Values are:
Item Label Value
Select All-- (I left this blank)
Bicycles--Bicycles
Motorcycles--Motorcycles
Skateboards--Skateboards
My results page seems to be okay. I created a recordset and a dynamic table. In recordset, the default varable that was created shows Name: colname
Type: Text
Default value: -1
Runtime Value: $_POST['2']
Problem is that when I select one of the items from the list on the form (ex. skateboards), my results page shows all records for skateboards. When I select "Select All" from the list, I don't receive any records. What can I do to allow user not to enter any value and have him receive all records?
Thanks in advance....
I created a generic form with one list on it and a submit button. Values are:
Item Label Value
Select All-- (I left this blank)
Bicycles--Bicycles
Motorcycles--Motorcycles
Skateboards--Skateboards
My results page seems to be okay. I created a recordset and a dynamic table. In recordset, the default varable that was created shows Name: colname
Type: Text
Default value: -1
Runtime Value: $_POST['2']
Problem is that when I select one of the items from the list on the form (ex. skateboards), my results page shows all records for skateboards. When I select "Select All" from the list, I don't receive any records. What can I do to allow user not to enter any value and have him receive all records?
Thanks in advance....
AdChoices