Switchboard Manager

[JamesJ]

I added an item to my switchboard to run a function
but it tells me it can't find the function. Spelling and
all has been double checked and are fine. The error number
is 2517.
It's a function to close the switchboard form and show the
DB window:

Function ShowDBWindow() As Integer

DoCmd.SelectObject acMacro, "Autoexec", True

End Function

 

[JohnE]

JamesJ, try adding this in your function;

DoCmd.Close acForm, "Switchboard"
SendKeys "{F11}", False

This should work.
*** John

 

[JamesJ]

Sorry, I'm running this function in the OnClose
of the form. The reason, I found out, it
couldn't find the procedure I should have
put just the function name without the = and ().
Just habit.

Thanks,
James