How to Open Second Form when Database Opens?

[djclntn]

Under Create – Macro/Add new Action I choose open Form & select the Form’s name. Close & open database & second form does not open. Any suggestions, please?

[June7]

What event are you using to trigger the macro?

[djclntn]

Hi June, thanks for responding. I don't understand what you mean by, "event?" I don't see "Event" in the Macro set up windows. To clarify, when I open up a dbs I would like to know if/how 2-Forms (Form-A & Form-B) open simultaneously upon dbs opens.

[Missinglinq]

I'm a little hazy as to your exact scenario, but if you want to run a given Macro, when the database opens, the Macro would have to be named AutoExec.

Alternately, of course, you could go into Access Options - Current Database and select the given Form in the 'Display Form' dropdown box.

Linq ;0)>

[June7]

An event is a button Click or form/report Open or form/report Load or control/form/report BeforeUpdate, AfterUpdate, etc.

If you want an Action to occur some Event must execute that Action.

For example, click a button to run code that opens a form or report.

You want to automatically open a 'second' form so what Event must happen to execute the Action? Code in 'first' form Open or Load event?

[djclntn]

ling, thanks for responding. I know about your alternative suggestion, but I want to have more than one Form open when dbs is open/started. I once (way back) had a dbs where 2-Forms opened when dbs was opened, but I don't remember what/how I did.

[djclntn]

I can't understand what you're saying. When creating a Macro I don't know how to have it be, AutoExec? Might you guide me on creating a AutoExec Macro?

[ItsMe]

If the name of the macro is AutoExec, the macro will execute at StartUp.

[djclntn]

Thanks, that worked! I suppose Access only lets up have 2-Forms open upon Startup?

[ItsMe]

Additional code can open additional forms. Not sure what the maximum is but I will guess it is many more than two and would depend on the machine's available RAM.