Using MS Access/Command buttons
Back again, this time seeking assistance with a command button.
I have two forms, one frmSplash, the other frmMain.
On opening the database, the frmSplash is virtually a welcome screen giving some detail of the database. The other form frmMain is the Main Menu for the database.
On the frmSplash form I have a command button. If I use the wizard to create the button, Access does this, successfully I might add. On clicking the button on the splash screen it opens the Main Menu.
What I want the button on the Splash screen to do however is to open the Main Menu and close the Splash screen.
I canít seem to be able to edit the macro produced for the on click event to do this successfully; is this possible? If so how do I go about it?
Maybe I would be better off using VB code. Once again could you help with this please?
Many thanks Scott
Sorry, this slipped past me.
In VBA its easy. After the OpenForm method add:
DoCmd.Close acForm, "formname", acSaveNo
In macros there should be a Close Action that will do the same.
Hope this helps,
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA