Redirect page to record that was just inserted?

Hi,
I have a page with textboxes and a save button. Basically a user fills in the boxed and hits save. The record is then inserted into a sql database. Problem is if I dont redirect the page, if the user hits save again it will insert a duplicate record instead of running my update qry. Is there a way to redirect the page to the current record inserted so that my update qry will run instead of the insert? Thanks
...