I created a database using the wizzard and on the switchboard I open the form and it automatically goes to the first record that I inputed. When I open the form from the switchboard I want it to go immediately to a new record so that the old records are not overwritten accidently. I've tried to do this using a macro, but it won't work. I'd appreciate any tips. Thanks

I am new to Access, but here are 2 things you might try: In your form's properties is a setting called "Data Entry". If you set this to YES your form will always open at a new record, ready for data entry. The drawback: you can't view the existing records, so you might want to make a copy of your form - one for browsing and one for data entry only.

Or, add a command button to your form (using the wizard) and choose Record Navigation/Go To Last Record or choose Record Operations/Add New Record. I think the last one would be your best bet. Hope this helps.
dp