Command Buttons Stopped Working on Form

[genest11]

Hi,



I moved some Command Buttons on an input form and they stopped working. I needed to move the buttons to make room for a new report and after I created the new Command Button with the wizard I got:

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

This happened on all of the buttons. No matter which button I push I get the same error message.

Any suggestions on what I did to make a mess of my form?

Thanks!

[RuralGuy]

Does your button stinn have something in the Click event? What is it?

[ssanfu]

Ambiguous name detected: HOME_Units_Click

Usually that error means there are two or more controls with the same name. Could that be possible??

[genest11]

RuralGuy,

Yes, [Event Procedure]

[genest11]

ssanfu,

Nope, all buttons have different names.

[ssanfu]

Is there any code anywhere that has the same name.

For instance, if you copied the button from Form1 to Form2 (button name stayed the same), created new code for the button on Form2, but didn't delete/change the name of the button on Form1.

Also, in the IDE, have you tried the Compile command?

In the IDE, do a find for "HOME_Units_Click". How many do you find?

[genest11]

ssanfu,

Okay, now I will show my ignorance "IDE"?

[genest11]

Here's an example of what I see under VB:

Private Sub Command148_Click()
On Error GoTo Err_Command148_Click
Dim stDocName As String
stDocName = "Subsidy Source"
DoCmd.OpenReport stDocName, acPreview
Exit_Command148_Click:
Exit Sub
Err_Command148_Click:
MsgBox Err.Description
Resume Exit_Command148_Click

End Sub

[genest11]

If I deleted all of the buttons and rebuilt them, do you think this would correct the problem? I did look under VB and I noticed two of the reports had: "Private Sub HOME_Units_Click()" as there first line.

[ssanfu]

IDE = integrated development environment
Where you can type the VBA code.

Multiple form/reports can use one subroutine, but there can be only one subroutine named "HOME_Units_Click" (Private Sub HOME_Units_Click())

Did you search the VBA code for "HOME_Units_Click"? Keep track of where the code is located - what form or module..

[genest11]

ssanfu,

"Did you search the VBA code for "HOME_Units_Click"? Keep track of where the code is located - what form or module.. "

Yes, I did! See my response above.

[ssanfu]

OK, sorry. Just checking

Then the only thing I can suggest now is to delete the data (in a copy), do a compact and repair, zip it and post it. I won't be able to look at it until tonight, but maybe Allan (RG) or some one else could look at it sooner.

[genest11]

ssanfu,

That was it! The double "HOME_Units_Click" in the VB. I deleted the duplicate and all is well. Thank you for your help.