finding record using combo box

[boatman37210]

New to the forum. Appreciate any help I can get.

When I place a combo box on my form and select a customer name to pull up a record, it says "ambiquous name detected" and takes me to a code screen. There are a lot of references to delete record - click. When I get out it states that debugging will stop. I get the impression that it is wanting the correct code.

I'm no access guru which I'm sure is obvious. I know nothing about code. I basically use wizards. Used combo box wizard to add the box to the form. I can usually edit a report fairly well, but adding a combo box to look up a record is something I have never done. Any idea what the problem is?

Thanks.

 

[missinglinq]

Two things to remember about errors at runtime:

First, the line of code is not always the line causing trouble. Often times its the preceeding line.

Secondly, you sometimes do something seemingly innocuous and forget about it and then do something else (such as adding a combobox) and test it and POW! it crashes.

So, we need to see the code on either side of the hilighted code as well as the "There are a lot of references to delete record - click" stuff.

The combobox wizard to retrieve records is pretty straight forward. You do, of course, have to have controls on your form that are bound to the fields you want retrieved.

The debugging has to stop to exit the code; if you exit without stopping the debugging Access won't let you do anything else, i.e. you can't close the form or close Access for that matter.