Paul has attended:
Access Intermediate course
Access Advanced course
On Starting Database, show specific form
How do I tell Access to open a specific form (The Menu) when I open my database?
RE: On Starting Database, show specific form
Hi Paul, Thanks for your post, I hope you have enjoyed your Training with Best Training. In response to your question there are 2 ways in which this can be accomplished.
1. From the Database window, choose the Menu option Tools, Startup, in the dialog box that appears, from the right hand Text box drop down, choose the form that you wish to display, (The Menu). The next time you open that database the form will display automatically.
2. Create an AutoExec macro (name your macro AutoExec) which opens a Form of your choice, (The Menu) then when you open the database, Access will run the Macro before anything else.
3. There is another method which would entail you creating a Switchboard, on the switchboard you would have a click option to open your chosen Form.
Hope that helps, regards Pete.
