Just want to have 1-Form open when open database

[djclntn]

Since it's the New Year (Happy New Year to all) I went into 'File' - 'Options' - 'Current Database' & change the Form under 'Display Form.' When I closed & reopen the database the first Form that automatically open is the Form I had selected under, 'Display Form.' However, the original Form that I had automatically open is still automatically opens each time I open the database. I don't know how to stop this second Form from automatically opening; I think that it might be a marco, but there's no code in the VBA? If it is a Macro how/where do I delete it? Any help/suggestions would be greatly apprechated!

[JoeM]

Do you have a Macro named "AutoExec"?
"AutoExec" macros are automatically run when a database is first open, so it is also another popular place to open Start-Up forms.

[djclntn]

Thanks for responding to my post. Yes, the macro is named, "AutoExec"; might you know of a way I can end/stop the macro? thought about deleting the form itself which I rather avoid.

[June7]

You can open the macro in design view and edit it. Or you can delete it entirely.

[ItsMe]

Changing the name of the macro may be an option. This way you can still use it but not have it automatically run at startup. Call it when you need it. Just depends on what is in the macro and how you decide to edit it.

[djclntn]

Hi June, as I said I'm not Shesure about how to go about editing a macro. in Design View I open the VBA xx it's blank. In the Property et under, "Event" everything is blank. I'm not sure where to go? If I may, Happy New Year!

[June7]

Macro code is not viewed in the VBA editor.

Macros listed in the navigation pane are not tied to any particular object. They can be called in an event property or by VBA code or by another macro.

Right click on the macro > Design View.

[JoeM]

I usually do what ItsMe recommends. Just rename it. If it is named anything other than "AutoExec", it will not automatically run upon opening the database.
But then you still have a copy of it, if you need it.

[djclntn]

I'm sorry June, but I still cannot find/locate this Macro. When you say, "Right click on Marco" where? In Design View I tried to Right click on, "Run Macro" that didn't work. Might you be a little more precise? Please excuse my ignorance & as always I thank you for your time!

[JoeM]

Access has different Objects. These Objects are Tables, Queries, Forms, Reports, Macros, and Modules. Usually, on the left-hand side of Access, you have an Object Explorer where you see all these objects. If you have any Macros, there should be a Macro section over there. Note, it may not be visible by default. You might need to click the drop-down box next to "All Access Objects" in the Object Explorer and select Macros to see it. Once you see it, you can rename it, edit it, etc.

By the way, how do you know you have an AutoExec macro if you can't already see it.

[djclntn]

Thanks Joe,solved the issue!