Problem with Buttons

[SeniorCitizen]

I have a form that I use for navigation with a button for each task. When I select any button I get the following error message. The form has been working well until I added a new button.

The expression you entered on click as the event property setting produced the following error: A problem occurred while 'mt database' was communicating with the OL Server or Active X control.


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

For testing purposes the procedure on click is merely a msgbox

No indication what to do about it.

[June7]

Post your code or provide database for analysis.

[SeniorCitizen]

Private Sub BtnIndividual_Click()
'Me.LstNames.Visible = True
'Me.BowlersID.Visible = True
MsgBox "Hi"

End Sub
This is the code of the new button.

[June7]

Don't see anything wrong with that.

Possible corruption. Try deleting button and code and recreating.

[SeniorCitizen]

I Have tried that with no success. This is just the new button but all buttons yield the same message

[Edgar]

It could also indicate incomplete code within a module or class. Keep in mind that not all errors are accurately reported, so it's important to thoroughly check all your modules. There might be a typo in a variable declaration, subroutine definition, or a missing control. I once encountered a similar situation when the name of my initial form had changed. Access was expecting "FormX," but I had renamed it to "Main," resulting in the error message without any specific indication of the problem's location. Therefore, consider reviewing the places where the form name or the click event is referenced, such as macros or other options, that may not be present in any module or class.

[June7]

At this point, suggest provide db for analysis. Follow instructions at bottom of my post.

[Gicu]

Try to recreate the form and delete the old one:
https://stackoverflow.com/questions/...g-with-the-ole

I found the easiest is to start with an new empty form in design view, set any necessary properties such as back color, background picture, etc. for the form sections (header, detail and footer) then select all controls in each of the section in the original form and do a copy and paste. Once done copy the entire form module in the VBE window to the new form (usually this works without you having to manually reattach each procedure to the corresponding control), save it with a new name, delete the old one, rename it with the original name and run a compile and repair.

Or you can also try to import all your objects into a brand new Access file, making sure you adjust the VBA references to fit your project.

Cheers,

[CJ_London]

perhaps you are missing a library reference?

[SeniorCitizen]

Thanks guys for the suggestions. I recreated the entire form with cut and paste and all is well. The problem is gone.

Thanks