Ambigious name detected....

[nickrugado]

Compile error:
Ambigious name detected....

first line is highligted in yellow...
5th line where it says 'displaymessage' is highlighed in blue.

Several areas in the DB where this code exists... is something formatted incorrectly??

Private Sub PhEmDate_Enter()
On Error GoTo Err_PhEmDate_Enter

If IsNull(HowHeard) Then
DisplayMessage ("Please select one of the 'How Heard' choices.")
HowHeard.SetFocus
Cancel = True

End If

Exit_PhEmDate_Enter:
Exit Sub

Err_PhEmDate_Enter:
MsgBox Err.Description & " Error Number " & Err.Number
Resume Exit_PhEmDate_Enter

End Sub

 

[Remou]

Ambiguous Name Detected means that you have two or more procedures with the same name and the same scope.

 

[nickrugado]

I have left the code in there... it does exist in another place but the trigger field is a different name.

I made it where there was only one instance in the module and the error was still happening.

I have brought all of this code into a clean database, and I was wondering if ...

where in the code it says DisplayMessage.... if that shouldn't be MsgBox... I have replaced DisplayMessage with MsgBox and that has corrected the issue. But... Was that really the issue???

Help

 

[PHV]

Search the whole project for DisplayMessage
I guess you've defined this name several times.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886