Is Access corrupted??

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

Here is my delima.

I have a form, dosn't matter which I have tried several.

I try to insert a "Close Form Button" on my forms and

it "Seems" to do ok except.. when I try to use it I get

the popup error below.





The expression OnClick you entered as the event property setting produced
the following error:

Ambiguous name detected: CloseFormButton_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







This box comes up even if it's a command button to open another form. I have
tried on a different

Form in another database and get same results.

Whats up. Has things in Access corrupted and I need to reload. I have
installed SP3 for Office 2000.

This started when I tried to install a text box on the bottm of my form to
Sum an Extended price field.

If anyone knows answer to this.... Please Help



TIA

Donny
 
Hi Don,
In Design view, click on the Code button on the
toolbar. Check the code to make sure that the procedure:
CloseFormButton_Click is not in there twice. Check to make
sure that all other procedures are unique. If everything
looks okay, you might have to consider rebuilding the form.

Hope This Helps
 
Art's reply is correct. You have more than one occurrence of a procedure or
function called CloseFormButton_Click. This is a "compile time" error, not a
"run time" one. You must have changed your code, then tried to run the form.
Before Access can run the form, it must "compile" the form. The error
occurred when it tried to "compile" the form. You can compile the form
yourself, at a time of your choosing, by clicking the compile button on the
forms toolbar. I forget what that button looks like (& I don't have Access
here to check), but you could doubtless find it by looking at the tooltips
or consulting online help.

HTH,
TC
 
Back
Top