Form Events not working. Urgent

[Lysander]

Using Access 2003

Last night I created a new form, nothing special or funny about it. It has 3 toggle buttons on it, and I put an after_update event on them but it failed to work.

I now find that no event will work on any control in that form. They all give the same message

"The expression After_Update you entered as the Event Property setting produced the following error: Object or Class does not support the set of events"

The code in the form is like really basic and just there to test the events.

Anybody any idea what is going on as this has me stumped

Option Compare Database
Option Explicit
Private Sub DoubleCorrect_AfterUpdate()
If DoubleCorrect Then
    MainCorrect = False
    NeitherCorrect = False
End If
End Sub
Private Sub MainCorrect_AfterUpdate()
MsgBox "Hello"
End Sub
Private Sub MainTableValue_AfterUpdate()
MsgBox "Hello"
End Sub
 
Private Sub NeitherCorrect_AfterUpdate()
If NeitherCorrect Then
    MainCorrect = False
    DoubleCorrect = False
End If
End Sub
 
 

[puppydogbuddy]

Using Access 2003

Last night I created a new form, nothing special or funny about it. It has 3 toggle buttons on it, and I put an after_update event on them but it failed to work.

I now find that no event will work on any control in that form. They all give the same message

"The expression After_Update you entered as the Event Property setting produced the following error: Object or Class does not support the set of events"

The code in the form is like really basic and just there to test the events.

Anybody any idea what is going on as this has me stumped

These are all AfterUpdate events for controls, which are not triggered until something has been keyed in. Programmed (background) updates do not trigger the AfterUpdate event for a control, but they do trigger the after update event for the form.

[Lysander]

These are all AfterUpdate events for controls, which are not triggered until something has been keyed in. Programmed (background) updates do not trigger the AfterUpdate event for a control, but they do trigger the after update event for the form.

Hi Puppydogbuddy,

I am keying something in. What I wanted to do was set the other two fields false after the user clicks one true. ATM, I can't get any event to trigger on any control in this form, I keep getting the error message from Access.

All the events on all the other forms work fine, its just this latest form giving this error.

[puppydogbuddy]

Hi Puppydogbuddy,

I am keying something in. What I wanted to do was set the other two fields false after the user clicks one true. ATM, I can't get any event to trigger on any control in this form, I keep getting the error message from Access.

All the events on all the other forms work fine, its just this latest form giving this error.

Then, I would venture to say you have a corrupted form, unless the error message indicates otherwise. Did you check to see that the event property for each of the controls shows that the AfterUpdate Event has been set?

[Lysander]

Then, I would venture to say you have a corrupted form, unless the error message indicates otherwise. Did you check to see that the event property for each of the controls shows that the AfterUpdate Event has been set?

Looks like corruption. Tried compact and repair, then decompile, still no joy. Then found this on a google search and it fixed the problem. Seems its a known access bug.

Application.SaveAsText acForm, "fsubDoubleEntryCorrectionDetail", "C:\fsubDoubleEntryCorrectionDetail.txt"

Then delete form and do

Application.LoadFromText acForm, "fsubDoubleEntryCorrectionDetail", "c:\fsubDoubleEntryCorrectionDetail.txt"