Solved: auto-launch a form

[cmpgeek]

I have looked in the KB, but didn't see anything there that will help me. What I am wanting to do is set up a file so that when someone opens it, the form they will be using automatically opens.

I am running Access 2000 (9.0)

any help would be greatly appreciated.

Thanks,
Nomi

[OBP]

Hello, there are two very easy ways to achieve this.
1. On the Main Menu, click Tool>Startup and on the right hand side click the drop down and choose your form.
2. This one gives you a bit more control, create a Macro, choose to open a form and then choose your form. Then chose "Maximise", which will maximise your form. Finally save the Macro with the name "Autoexec".

[cmpgeek]

I don't know how to create a macro in Access. In Excel you get the option to record one and I can usually start with that and then tweak it with VBA if I need to; I dont get that option in Access and I don't know enough VBA to even know where to begin these steps.

I used your first suggestion and that does have it opening, but I would also like for it to be maximized. Do you know what coding I would need to add for that?

Thanks for both of your suggestions! I truly appreciate your help!

[OBP]

Access has a Macro writing wizard that helps you create the macro with drop down lists of actions an in the lower box at the bottom of the page it has drop down lists of the tables/queries/forms/reports that you want the action to occur on. You should give it a go.
The code for Maximising the form ges in the "On Current" event procedure of the form and it is
Docmd.Maxixmise

[cmpgeek]

After a little searching I finally found the macro wizard you mentioned.
Thank you so much! This will be a tremendous help!

thanks again! :bow: