Open database to different form

[Demetious]

I'm sure this is simple but, how do I change the default form opened when I start my db? Thanks

 

[the_net_2.0]

in 07, options > current database

in 03, options > "startup" tab (i think)

 

[Demetious]

Nm all, I found it. =)

 

[Dairy Farmer]

You can also change the Startup Form in VB.

CurrentDb().Properties("StartupForm") = "Form_XYZ"

Example:

You have one main menu

You have 2 different departments.

Each department has its own menu
Finance Menu = Ledger, Payments, Invoices
Sales Menu= Orders, Quotes

Sales doesn't need to goto the Main Menu everytime at startup, but would rather goto the Sales Menu. On the departmental menus you could have a checkbox "Make this my default menu". Clicking this will change the startup form.