Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ambiguous name detected-When I open a Report from a Form 1

Status
Not open for further replies.

LARod

Technical User
Apr 8, 2008
3
US
I'm new with this...I created Reports and when I make buttons on my master form to open them, all of them recieve this message:

The expession On Click you entered as the event property setting produced the following error: Ambiguoug name detected: All_Job_Info_Click.

*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.

So then I tried to changed from Open Report to Preview Report and I still recieve the same message and I can't seem to figure out how to fix it. The weirdest part is that the reports where originaly working, but then after doing updates to the tables they where not. So, I redid all of the reports and still I get:

The expession On Click you entered as the event property setting produced the following error: Ambiguoug name detected: All_Job_Info_Click.

*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.

Please advise....thanks.
 
normally this is where you have a public variable or subroutine with the same name. You probably did a copy and paste so now you have two events with the same name, thus "ambgious". Trying selecting "Debug", "compile Access" from the vba window. I think it will point out where the duplicate name is.
 
Thank you...I check in the vba window and there where many instances..I thought that after I deleted a physical button it would go away but it didn't, so I cleared all instances of report buttons and now everything works....thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top