On click event error

[Guest]

i have created a button which works fine until i add another button, then i
get this error once i click either of the buttons
this is what the error states
The expression on click you entered as the event property setting produced
the following error: member already exist in an object module from which this
object module derives

can anyone help me??

thanx
fvela

 

[Graham Mandeno]

Hi Fvela

This error occurs if you have two objects in the same scope with the same
name - for example, a control on your form and a VBA function.

The first thing to check is that your code compiles OK. From the VBA
window, click Debug>Compile <projectname>, and chances are the offending
line will be highlighted. Change the name of one of the objects and you
should be OK.