that was not clear from your initial post, the additional information changes the answer completely, ignore the previous responses.
dont use 2 recordsets, only the 1 recordset.
You need to use data assist search for this.
make sure the initial option of your list set to a blank value:
<option value="">Show All</option>
Set data assist search to filter the price column of the rsOffers recordset using the maxPrice select list.