The code should be on the form action page. Validation code should appear below the recordset code but above the insert code, and they should all be on the same page and not on the success page (blank action submits to the current page).
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.