I'm a little confused, you applied the filtering to the rsPrice recordset, but you are not using that recordset anywhere on the page?the only recordset that is used on the page is the rsOffers recordset?
Well, I created the rsPrice recordset to create the filter for the Search By Price select list that you have been helping me with in this thread. I thougt this would then be displayed by the output of the maxPrice form
<form id="frmPriceRange" name="frmPriceRange" method="post" action="">
<label>maxPrice
<select name="maxPrice" id="maxPrice">
<option value="500">Up to £500</option>
<option value="700">Up to £700</option>
</select>
</label>
<label>
<input type="submit" name="button" id="button" value="Submit" />
</label>
</form>
The rsOffers is to simply display all records from the DB.
Please advise me as to what I need to do now to get it working.
