Easy question: Selecting the main form to execute at opening a .mdb file

[videoclocknet]

Hello,



this is my first post in this forum. I'm new in Access, so I think you can help me in that.

I have some forms in my .mdb file. When I open my .mdb file, a form (let's call A form) is executed. Now we have created a new form with more features (let's call B form), so we want B form to be executed at opening the .mdb file instead of A form. B form calls A form, so we don't want forms names to be changed.

Is it possible?

Thanks.

[TheSmileyCoder]

Yes it is.

In Access you goto Tools->Startup and there you can set which form to open initially.

Inside Form B, you can then add code to open form A. This could be done in 1 of several events, depending on your need. For example the Load / current / close, or at the click of a button. The code to use would be:

Docmd.OpenForm "frm_A"
'To close the form b
Docmd.Close acForm, Me.Name

[videoclocknet]

Yes, yes!

Thank you very much!

Your help is very appreciated!

[TheSmileyCoder]

You are welcome. Glad to be of assistance.