Error on opening (1 Viewer)

I'm getting "the Expression On Click you entered as the property setting produced the following error... may not result in the name of a macro/may have been an error evaluating the function ".
You OK that and it just returns although I managed to fluke past it and did compact and repair and Debug-Compile. Neither of these complained or raised an error.


Can anyone help me find what causes this and fix it ?
Thanks.
Also how do you get past the error msg reliably? I click or shift click many times and eventually it goes away but without any logic why!

Debug it and dont use xxx_Click() as your udf.

I could be that you have reused the database or module name for a procedure. These names are special and cannot be duplicated for other objects.

It was weird. I opened holding Shift and remmed out the last 2 procedures I'd written, It was fine... so I unremmed them and it's still fine.
Ok on don't use xx_Click. I see why.