Error Message on Events

[Maestro]

An easy one for someone, I hope.. Every time I try to run an [Event Procedure] from my form, whether it's one I've coded myself or even a simple delete or search records command generated by the wizard I get the following error message:

"The expresson On Click you entered as the event property setting produced the following error: Ambiguous name detected: Labels)_Click."

This means little to me! I went through the code and took out any instances of commands containing "labels_Click" but just got the same message with "something else_Click"! The problem is bound to be something obvious, but I can't make sense of it.

 

[charityg]

Could you email me a text version of your code to take a look at?

 

[Maestro]

Thanks to 'charityg' I have been able to eliminate the problem, the code was full of duplicated procedures and basically needed a bit of a tidy up. However, hoving now deleted some of those procedures, whenever I attempt to read the code of my form I get a message telling me there's a DLL missing and it can't open it. Very odd, as visual basic works OK and the form functions correctly. More of a general access thing, but does anyone know what I might have done to cause this and how best to get around it?