Hi,

Really battling with this concept, I have a products page with a single list menu above it. The values are new, used and spares when the user selects an option the page will search database for items in that category and list the items below.

This is how I approached it, I have a recordset to show the categories table available as options and bind that to the list box then I have a recordset for the data on the for the records in the database ie. Product, Price etc.

Now how to pull the category chosen as a query and send it to the next recordset to display the selected data.

Help would be appreciated.

BTW It is only one list menu.

Thanks,