Hi Guys,

I'm new to this forum, but in the last few hours browsing through - I found a lot of useful info, anyways on to my problem...

I'm using dreamweaver 8/ASP VBScript to create a webpage for uni coursework.

I'm new to both - so please forgive the n00bness...

I have a webpage with 3 categories (www.soapsforthesenses.com) and in one category page I want to display specific records related to that category. I use the SQL statement to show these records from my Access database:

*SELECT
FROM Products
WHERE Product_Type='BW'

Product_type being my field
and BW being my record identifier

now I need to create recordset scrolling throughout the entire database (all categories) using first next previous last.

but when I set this function, it only shows the records pertaining to my SQL statement. Can anyone PLEASE help?

Thanks
Nick