On click event error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top