Hi Sarah,
I'm not too experienced myself, so this might be wrong and/or not work for you, but I hope it does!
I'm kind of doing the same thing myself, treating them like pages, and so I thought I'd share how I'd done it.
I've used Macros for mine, if you go on the 'create' tab and look on the right hand side, you should see the button. This opens up the macro maker tool thing.
First things first, you want to open another form BEFORE you close the current one, just since once you close the form, you cant run any further code...it will be gone. So, instead open the next form then close the previous one. It's also quite simple to use, so that's an added bonus!
Where it has a box reading 'Add new action' start typing 'Op' and it should select 'OpenForm' for you. Just press enter to bring the whole thing up. I'm assuming you'll be able to sort yourself out from there regarding this, but just in case you can't:
Where it says 'Form Name' type the name of your form, and underneath if you want the user to view it in form mode, leave everything else as it is. If you want it to open in design view etc, just click the drop down arrow and choose the option you want.
Go back to Add an action, this time typing 'CloseW' and press enter, this will bring up the 'CloseWindow' macro step, choose 'Form' for your object type, and then type the form name in the section below!
Right click where it says Macro1 on the tab below to toolbar to click save, name it whatever, and then close it.
THEN,
Go to your form which you want the user to click the command button you've mentioned and then look to property sheet. (if the property sheet doesn't show, right click on the form and then form properties, clicking your button again)
If you aren't already on the 'event' tab, click it, and you should see a 'on click' button, click the down arrow here and simply select whatever name you saved your macro as! This should work for you. ^^
