how would i make it so that the a form automatically opens with the db is opened.

How would i  make it so that  the  a form automatically opens with the access is opened. My program only has 1 form.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
set on the Display Option the name of your form

OffIce > Access options > Current Database

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rey Obrero (Capricorn1)Commented:
set on the Display Form Option the name of your form

OffIce > Access options > Current Database
vbnetcoderAuthor Commented:
Not sure how to get to office -- what do you mean by that?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!


Rey meant the Office button if you have Access 2007. Since Access 2010 it is the purple "File" tab instead, the rest is the same.
In versions before A2007 you can find that in the Tools menu as far as I remember.
As Rey already answered that, this was only an additional hint, no solution.


vbnetcoderAuthor Commented:
i have office 365
Office 365 is only a licence model as you normally get the newest version always.
If you look at the top left corner of a started Access you should see the "File" tab which is in Access 2010 and Access 2013 (and I guess also in Access 2016). As far as I know Office 365 started with Access 2010.
Rey Obrero (Capricorn1)Commented:

File > options > current database
Keyboard CowboyCommented:
You can also put in an autoexec macro - and have it only open the form.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
After you pick File > Options > Current Database, you will see a dropdown for Display Form with a list of the forms in your current database.

Optionally, you can define a macro named AutoExec (capitalization is optional) with:
Action --> OpenForm
     Form Name  --> pick the name of your form from the dropdown list.

In the AutoExec macro, I usually do this as well:
Action --> Maximize

If you are using Tabbed View, this will have no effect.  I prefer, however, to also set the Options to Overlapping Windows:

File > Options > Current Database
under Document Window Options:  check 'Overlapping Windows'
vbnetcoderAuthor Commented:
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ;) ~ happy to help
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.