It is probably just the order of the code on the page.
You can probably just copy and paste the insert code above the recordset code so that the insert takes place before the recordset is created so that it will contain the newly inserted data.
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.