On Click error

[artemisia]

I created several buttons: Add New Customer, Find a Customer, Add New Order and Edit Order using the Command Button Wizzard.

The following message appears when I click each button:
The expression OnClick you entered as the event property setting produced the following error: Ambiguous name detected: Look Up Customer.
* The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event or macro.

What am I doing wrong?
Any ideas on how to fix this is appreciated.
Thank You!

 

[Mile-O]

You have two subroutines in your form's module that have the exact same name - removing the unnecessary one will remove the ambiguity over which routine to execute.

 

[artemisia]

How should I do that.
I'm a newbee.

 

[YvesX54]

ALT+F11 opens visual basic editor --> search for your project (lefthand pane), then expand until 'Modules' --> 'Module1' becomes visible, doubleclick this node --> search for the ambigeous function or sub and remove one of them.

Hope you find it.
Regards, Yves

 

[YvesX54]

The events triggered by your buttons are not in Module1 but in your form's 'environment code' --> Node 'Microsoft Access Class Objects' --> Form_<your form>

My mistake.