MS-Access 2007 - Switchboard edit failing??

[techexpressinc]

MS-Access 07 - It displays ugly. I try to edit the swithbox and the pop-up
message happens:


"Compile error, in query expressing 'IIf(IsNull [Arguement]),"',([Arguement])"


And that is it. No editting allowed?? How can I patch up the current switchboard or must I trash it and start all over, there is a cute graphic in
the current one so I prefer to fix it.

More info -

It happens when I - click Database Tools - Switchboard Manager - select the
name (default) switchboard - and click Edit.


I did a screen print of it.
The exact error message is at the URL

http://www.box.net/shared/713zefoltg

Thank you for any and all help.

Russ @ techexpressinc.com

and

Rneuman @ scaninc.org

 

[wayneryeven]

what event procedures have you runnning on opening the switchboard?

 

[techexpressinc]

--------------------------------------------------------------------------------

I found the problem. I had some bad VB code. That caused the edit of the switchboard to fail.
I had some extra comments in front of the VB code. I removed them and all is running smooth.
The Switchboard had not worked for 3 months since I installed my bad code the last quarter's reporting time.
To see the age calculation VB with the extra front end go to the attachment.
There goes 4 hours of hitting my head on the wall.
Good Grief..
Russ