View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ca1358 ca1358 is offline
external usenet poster
 
Posts: 37
Default Close Switchboard Form

I have this piece of code that worked fine but I had the line to close the
Switchboard form and it doesnt work.

App.Application.docmd.closeform "Switchboard"

The Error states Object doesn't support this property or method.

Any help would be appreciated!

Code is has follows

'Open a form in Access
Dim App As Object
Set App = GetObject("\\Dtcnas-ilsp002\mandatory\Volume.mdb")


App.Application.docmd.closeform "Switchboard"
App.Application.docmd.openform "Form"

--
ca1358