When you are using Payments Standard there is a form element called 'return' that should be set to the page that you want the user returning to. This element is on your confirm page, you should check it here and set it to the URL of the page you want the user going to after the transaction occurs.