If you want a form to appear as the first thing you see when you open your database, you need to do the following.
Go to Tools on the menu bar and choose Startup.
Then a dialog box will appear. On the right hand side, you will see a combo box with all of your form names in it.
Choose the form you want to appear, and then click ok.
The next time you open the database, this is all you will see. If you want to bypass this, so you can get to your queries etc, either hold down shift when you open the db, or once it is open, to get to the database window, press F11. However, it is better to hold down shift as you then get full options (like you can right click on things in the db window).
Hope this is what you wanted.
