I was trying to put a button on a form that links to another form but when I did so I received an error message that brought me into the visual basic code. The error message stated "Compile error: Ambiguous name detected: Kick_Inventory_Click". Does anyone
know what this means?
One option that I didn't see Wayne give is that you simply have two of the
Private Sub Kick_Inventory_Click()
in there somewhere in the form module. So it could be like this:
Private Sub Kick_Inventory_Click()
Private Sub Kick_Inventory_Click()
or
Private Sub Kick_Inventory_Click()
Private Sub Kick_Inventory_Click()
...more code here
End Sub
or it could be
Private Sub Kick_Inventory_Click()
..code here
End Sub
Private Sub Kick_Inventory_Click()
.. code also here
End Sub
So basically you will need to find where it is. So, Go to the VBA window and to DEBUG > COMPILE < project namehere>
and try to compile. It should take you to one of the offending lines. It may be obvious at that point that it is the problem or it might be the other entry that is the problem. So, if that is the case then use CTRL + F to bring up the find dialog and
paste in this -
Kick_Inventory_Click
and select CURRENT MODULE
----- Microsoft Access MVP 2008, 2009, 2011 If a post was helpful click the FOUND THIS HELPFUL link
1 person found this reply helpful
·
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.