Access 2010 VBA Events not firing

Praedico

New Member
Joined
Jul 17, 2008
Messages
41
I have a form with a few subforms. The subforms have records. When I add a new record or edit a record on the subforms the Form_BeforeUpdate and Form_AfterUpdate events fire as expected and magic happens.

However when I delete a record from any of the subforms, no events are triggered. I can't figure out why and need them to. I've tried BeforeDelConfirm and AfterDelConfirm and just about all the other events available that would make sense. None of them work.

Some research through Google found that perhaps I need the database to be in a "trusted location" or that the "Confirm" boxes were checked in the options. All of that has been confirmed.

Help?

Thanks
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Solved - Sorta.
A restart of the database has somehow reset universe and the events are now firing for deleting records in the subforms. I don't know what changed but I no longer need help with this. Thank you for reading.
 
Upvote 0
Solved - Sorta.
A restart of the database has somehow reset universe and the events are now firing for deleting records in the subforms. I don't know what changed but I no longer need help with this. Thank you for reading.

I am having this exact problem but a restart of my database does not help. Does anyone have an answer to this?

Thank you
 
Upvote 0

Forum statistics

Threads
1,214,520
Messages
6,120,017
Members
448,937
Latest member
BeerMan23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top