If you are opening forms with a statement, you can use Goform, which replaces the form that is open with the new one in the same window. You may, of course, need to resize the window to accommodate the new form.
You could also use the code in an earlier post that will close other windows in the same database (you have to scroll down in this long topic.)