Compile Error - Ambiguous Name ???

[jacek.w.bak]

I filter report on open based on form w/ Customer, and Dates from/to
On Open procedure :

Private Sub Report_Open(cancel As Integer)
' Set public variable to true to indicate that the report
' is in the Open event
bInReportOpenEvent = True

' Open Sales By Category Dialog
DoCmd.OpenForm "Range", , , , , acDialog



' Cancel Report if User Clicked the Cancel Button
If IsLoaded("Range") = False Then cancel = True

' Set public variable to false to indicate that the
' Open event is completed
bInReportOpenEvent = False
End Sub

Returns "Compile Error" on Cancel Button
"Ambiguous Name"

I have no idea why this happens? Any clues?

[ssanfu]

So, in the report open event, you have code to open a form named "Range" in dialog mode. Something happens in the form "Range", then the form "Range" closes.

You drop back into the report open code, which then checks if the form "Range" is loaded (by now it is not) and cancels the report open event.

If you want to cancel the report open, you need to check if the cancel button was selected in the form "Range" *before* the form "Range" closes, pass the result to the report open code, then check to see if the report open should be canceled.

Returns "Compile Error" on Cancel Button
"Ambiguous Name"

Is this error from the Cancel Button code in the form "Range"?
I've found that this usually this means there are two (or more) 'things' (objects, variables) with the same name.