You are probably getting the wrong record from the recordset. Did you specify any sorting on the recordset when you applied it? You will have to sort the recordset so that the value you are looking for is the item that is being sent.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.