Access 2007 Switchboards

[eebhv6]

I am currently working on a database that was built for my office by an
employee who has moved away. When our computers were switched over to 2007
the switchboard form in this database ceased to function. When you press a
button on the form you get the following error.

The Expression you entered has a function name that microsoft access can't
find.

It then offers this "help"
This error occurs when an event has failed to run because Microsoft Office
Access cannot evaluate the location of the logic for the event. For example,
if the OnOpen property of a form is set to =[Field], this error occurs
because Access expects a macro or event name to run when the event is fired.

I realize that this means that the control tab most likely doesn't link up
to where it is supposed to link up, but I have no idea how to get it to link
up. Is there a simple point and click way to fix this. I am currently
trying to beef up on my access knowledge, but at this rate it would take me
twenty years to fix this. Someone please help.

 

[Jeff Boyce]

Here's an alternate approach, if you don't get assistance specifically on
fixing your Switchboard...

Many folks start out using the Switchboard provided by Microsoft Access, but
subsequently move to creating their own "menu" forms. This gives them much
more control over the program flow, and does away with the sometimes
complicated, sometimes confusing Switchboard.

If you decide to create your own menu forms, you can simply open a new form
in design view, add (one/more) command buttons, and tell those buttons where
to go/what to do. That it!

Good luck

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.