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_Cli ck.

*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]

Re: Ambiguous detected Find_Record_Cli ck

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.Micro soft.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]

Re: Ambiguous detected Find_Record_Cli ck

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

Mike Storr

https://www.veraccess.com

"ALAN MEWS" <alanmews@btope nworld.com> wrote in message
news:c24q4d$a7g $1@hercules.bti nternet.com...[color=blue]
> 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[/color]
advice[color=blue]
> 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_Cli ck.
>
> *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
>
>[/color]