Access Error Message says "Ambiguous name detected: Find_Record_Cl

G

Guest

I have created a database exactly like one we made in an online class. ONly
problem is one of my buttons will not work..When I am in my Main Order Form,
if I want to add an existing customer, I would click my contactID drop down
and select a name (which in turn would be filled into the Name, address, etc
blanks on the form - All that works well. But if I have a new customer; I
would click my new customer button and it will open my address book for me to
fill in the new customer info (ok at this point, all is still well). then I
click the Place Order Button and it is suspose to close Address Book; Open
Main Order Form with name filled in and the cursor in the payment method box.
What happens when I click "Place Order" button is the Message comes up
saying "Ambiguous name detected: Find_Record_Click"; then if I click OK, it
brings up a box ACTION FAILED and lists my Macro name "Order Form
Macros.PlaceOrder" and Condition: "True" and Action: "Set Value" and
Arguments: [Forms]![Orders Main Form]![ContactID],[Forms]![Address
Book]![ContactID] and the only option I have is to select a button reading
HALT. when I do It opens the Main Order Form and the information is not
filled in. The address book is still open in the background. The address
book is suspose to close before it opens up the Main Order Form. I have
compared my database with the one we made in class that works fine and I can
see no differences. I do not know what could be the problem.....can anyone
help me?
 
J

John Vinson

What happens when I click "Place Order" button is the Message comes up
saying "Ambiguous name detected: Find_Record_Click"

Open the Form in design view, and press the Code icon on the toolbar.
You evidently have *two* subroutines in the Form's Code module, both
named Find_Record_Click.

Delete one; or, if you're trying to use a Macro for this purpose
(which I would not recommend, VBA code is more powerful and more
flexible), delete both.

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top