URGENT (sorry i know it's annoying) Switchboard Problem

[enquiries]

Hi there,

Sorry I know it's annoying saying urgent and I hardly ever use it (actually never have) but this really is urgent. I've completed my database but a new problem has arisen, every time I close it down and reopen it the Switchboard Label (Main Switchboard) changes to copy the name of the last item on the list, no matter how many times I change it and save it.

I think it could have something to do with the fact that I'm using the table to manually add items to it and it's exceeded 20 items (it was okay up until then).



I can only change it in Layout view, in Design view in the property sheet it says caption: MAIN SWITCHBOARD but in the form view it says a different thing?

The name is Label 1.

Have no idea how to fix this?

Any help really appreciated

Thank you thank you thank you

[June7]

Odd, in my test it keeps changing to "Main Switchboard" when it should say "Umpires", no matter how few items are on the switchboard.

I never use switchboards because of the annoying behaviors they exhibit, such as create code for me. The wizard created several embedded macros. One of them is in the form Open event. Code in that macro sets the label caption.

I just build a normal form with command buttons and use only VBA, no macros. However, I guess there is some efficiency and consolidation benefits to the switchboard, since a single form can perform as several menus. But then why did MS deprecate the switchboard if it's so great?

[enquiries]

Hey Thanks for replying, yeah I think there's some code that's overwritten it somewhere but I can't find it, and I tried installing the link you gave on my other post but it gave an error that I needed up to upgrade my version (I'm using 2007).

I can't see the open event form - or anything other than the switchboard form and table, will research and have a play around.

If I was an expert at coding I'd so be over this switchboard doing my own thing lol, but sadly I'm at the grace of the access switchboard which is not delivering right now. Wish me luck

[June7]

I am not referring to an 'open event form', I was referring to the Open event of the Switchboard form.

[enquiries]

OMGGGG I SOLVED IT!!! I don't know if a colleague hacked in and added code or if it's like that at default which I doubt because it only started happening recently but I found an embedded macro on the open form event for the form property setting the caption value to the last item on the list. Removed that and it fixed the problem. Can anyone comment whether this is normal?

Thanks

[enquiries]

Thanks June, didn't read your post until after I commented Lol. Blonde moment - killed all my brain cells last weekend Lol, can I just ask though whether your one is set to the last item on your list in your open form event?

[June7]

It wasn't set to any of the item captions.

[enquiries]

Thanks, yeah I think someone might have of added actions to the embedded macros. Thanks again for your help.