Programatically Set Startup Form on a newly created Database

[Paladius]

Hello,

Within my Access program I create a new database using VBA. After the new database is created, I would like to set a form in it to appear on startup.

I have tried using CurrentDb.Properties("StartupForm")
but am not sure what I need to replace CurrentDB with in order to target the newly created DB.

or

Is their any way to export my "startup properties" of the current database to the newly created database?

thank you

[NeoPa]

How does your VBA do that? Does it use Application Automation? Does it close the currently open database first (If so, how is the code still running)?

To get a list of the available properties for a database I used the Immediate Pane of the VBA IDE and ran this code :

Set db = CurrentDb : For Each prp in db.Properties : ?prp.Name : Next prp

I expect the one you need is StartUpForm.

Also, you can find some working code I use for working with database properties in Database Properties. It may be of some help.