I'm looking for help. Here's my current setup:

- DreamweaverMX 2004
- ASP Pages
- Connect to MSAccess Database using a DSN-Less Connection
- Currently using Recordset to display all results (limit 5 per page)
- to see my work www.brooks.ca/hall/land.asp

What I am trying to do now is sort and display the records based on one field in the table. "Land_use"

I want the user to come to this page.... choose one of 5 fields in a drop down-menu (Industrial, Commercial, Single User Residential, Multi Family Residential, All).
Based on what the user chooses, only that group type will show up on screen (limit 5 per page)

I've never done this before, but I know it should be a simple type of 'filter'. But how does one go about applying this type of filter?
For Example.... do I go into the recrodset and Filter the "land_use" "=" "Form Variable" "drop-down list" ???
but then if that's true, how does it work for the 'ALL' variable.


I'm stuck.... can someone please help me?

Thanks,
Josh

Ok it's taken me all day and with a lot of help I've been able to create what I've been looking for. A page that will display depending on what is chosen from the Drop-Down Menu.

Still have a slight problem. If you go to the page you will see that when it first loads up you see 0 records. I can't make it display 'ALL' records as default.

I even created a seperate menu item, that when chosen, would display 'ALL' items. But it won't seem to do anything. Keeps coming back with 0 records.

I tried the following values:
[all]
*
&
%
$

and none of them seem to work. Is this a dreamweaver issue? Browser glitch? Or is there a command I'm not aware of to display all records.

Any help is appriciated!
Thanks!