Microsoft KB Archive/815284

= ACC97: &quot;Ambiguous Name Detected&quot; Error Message When Procedure Is Executed =

Article ID: 815284

Article Last Modified on 9/26/2003

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



Moderate: Requires basic macro, coding, and interoperability skills.



For a Microsoft Access 2000 version of this article, see 817411.



SYMPTOMS
When you run a procedure, you may receive the following error message:

The expression  you entered as the event property setting produced the following error: Ambiguous name detected: .



CAUSE
This behavior occurs when multiple procedures with the same name are in a module.



WORKAROUND
To work around this problem, you can delete the duplicate procedures. To do this, follow these steps:

 Open the form in Design view. On the View menu, click Code. On the Debug menu, click Compile Loaded Modules.

You receive the following error message:

Compile error:

Ambiguous name detected: .

 Write down the <Procedure Name> and then click OK.</li> Look through the code and find the other occurrences of the <Procedure Name>, where <Procedure Name> is the procedure that produced the compile error in step 3.</li> Select and then delete the unwanted procedure.</li> On the Debug menu, click Compile Loaded Modules.</li> On the File menu, click Close.</li></ol>

<div class="references_section">