Access Project Problem

Hi!

I have an access project open, and if the PENDING command button is clicked, it needs to close the current access project and open another(which has its own set of forms and tables). Does anybody have an idea how to do this.

To close the current project use END then use SHELL to open the new project.

Does access 2000 have END and SHELL commands. I never knew that..Could you give me an example as how to do that

Does access 2000 have END and SHELL commands. I never knew that..Could you give me an example as how to do that

You'll need to open the second app before the END command otherwise the first app will be closed and the SHELL command will not be run.

VB Code:

Private Sub Command1_Click()
Shell "C:\SecondApp.exe"
End
End Sub