Update Query Help - Prices and Percentages

[OminousDaark]

Hello everyone, I have not been using Microsoft Access for a while now although I am almost done with what I have to do I am stuck on one vital situation. Which is Update Queries.

I am trying to make an update query which when I click on a button on the main menu will simply allow me to enter in a number such as 10 which it will then raise the prices of everything in the field by 10%.

So far I have this in the Update To field:
[ProdSellPrice]+[ProdSellPrice]*[Enter a Percentage:]/100

As seen from previous thread I found (similar too at least) Although this does not seem to work, whenever I click on the button assigned to this query it comes up with a error message which says:

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

cmdDepartment is the name for another button I have set which simply displays all the Department information.

Thanks to everyone who stops by and offers me help

- Ominous

 

[Mihail]

In the VBA editor you have 2 (or more) procedures with the same name.
Remove one of them.

 

[OminousDaark]

Thanks for the reply - it appears I have two complete copies of each-other in it to do with the cmdDepartment_Click - In this case would I just take one of them out?

-----------

Edit - Thanks a bunch! - Removed it and tried it again and the error is gone it is now working 100%