Strange error message

J

Joe Myers

Using the tools wizard, I inserted a button to delete the
current record. With one record in the associated table,
I clicked on the button and received the following error
message:

The expression On Click you entered as the event property
setting produced the following error: Object or class
does not support the set of events.

The error message occurs before the code produced by the
wizard is run. The code procedure (named Private Sub
Del_Click()) looks identical to that produced by the
wizard in other applications. The form itself is quite
simple and was produced by the form wizard.
 
A

Allen Browne

First, check you don't have a references issue. From the code window, choose
References on the Tools menu, and make sure you don't have anything marked
"MISSING". More info:
http://allenbrowne.com/ser-38.html
If that's fine, choose Compile from the Debug menu. If you receive errors,
deal with them.

Next, see if you can delete a record manually by choosing Select Record from
the Edit menu, and hitting the Del key. If that doesn't work:
- Is the form a popup form, so you can't get to the menu?
- Is the form based on a non-updatable query, so records can't be deleted?

It that still doesn't work, check the On Click property of your delete
button. It should read:
[Event Procedure]
including the square brackets. Click the Build button (...) beside this.
Does this take you to the expected code?

If those suggestions don't solve the problem, post back.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top