Ambiguous detected Find_Record_Click

[ALAN MEWS]

Hi, Hoping someone can help me. I'm fairly proficient in using MS Access
2000, but got the following problem and would very grateful for some advice
as I am setting up (trying) this database for a charity:

After successfully setting up buttons to open and close Forms, including a
Query Form, a dialogue box suddenly pops telling me:
The expression On Click you entered as the event property setting produced
the following error: Ambiguous detected Find_Record_Click.

*The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

OK

Many thanks for any help as to where I should look to solve the problem
Alan

[ColinWard]

Hi.

you might already know all this but ...

You might have more than one control named Find_Record. If you do,
Access cannot figure out which control named Find_Reord you are trying
to code the click event for. Make sure that you only have one control
named find_record. Also, you should name your controls so that you know
at a glance what type of control it is and what it is supposed to do.
for example, if Find_Record is a button, you could rename it
btnFindRecord or btnFind_Record. the prefixes are as follows:

btn - command button
txt - textbox
cbo - combobox
lst - listbox

That is all the prefixes I can think of for now. I am sure if you look
up naming conventions on MSDN(MSDN.Microsoft.com) you will find a
document listing the prefixes for controls.

Hope this helps

Colin

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Mike Storr]

It may also be that you copied and pasted the event proceedure, resulting in
two subs with the same name.

Mike Storr
www.veraccess.com
"ALAN MEWS" <al******@btopenworld.com> wrote in message
news:c2**********@hercules.btinternet.com...

Hi, Hoping someone can help me. I'm fairly proficient in using MS Access
2000, but got the following problem and would very grateful for some advice as I am setting up (trying) this database for a charity:

After successfully setting up buttons to open and close Forms, including a
Query Form, a dialogue box suddenly pops telling me:
The expression On Click you entered as the event property setting produced
the following error: Ambiguous detected Find_Record_Click.

*The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

OK

Many thanks for any help as to where I should look to solve the problem
Alan