Actually, June7 was correct, prior to Version2007! But as of 2007, that changed. I was surprised to find this out, just now, as it hasn't been advertised anywhere as a new feature!
In 2007/2010, with the Document Window Options for the Current Databse set to Tabbed, all Forms are opened Maximized.
To change this, click on the Office Button (large button, top-left) then click on Access Options, go to Current Database, then change Document Window Options to Overlapping. You have to Close then Re-open the DB for this to take effect.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007