Forum Discussion
Access 2019 - List Box.Requery event on Main Form causes Sub Form Current event to trigger
Did you ever solve this issue? In 20 years of Access I don't think I've ever seen it before, but I've been fighting it for over a day now. My behavior seems identical to what you described
Recently had the same issue myself. Have a base form with 3 linked continuous subforms (SF1 links to SF2, SF2 links to SF3 in the standard format for this type of form). This worked without problem until I added a 'filters toolbar' comprising 2 toggle button option groups and 3 combo boxes directly on the main form. At that point I got the same issue described here, the On Current Event of SF2 firing multiple times. (I found any 'option' type control, i.e. radio button, toggle button, combo box, all controls of that ilk all caused the same problem, even unbound and disconnected from their event procedures so they are linked to nothing and should do nothing - same result!)
Assuming this was an error on my part, I spent an annoying 2 days pulling the form to pieces but couldn't find a problem with it.
I'll skip a lengthy ramble on various things I tried!
What resolved the issue for me was moving the controls that comprise the 'filters toolbar' to its own form, and then adding this as a subform to the main form. SF2 On Current now only fires 1 time as it should!
Am I missing something? or this is an odd bug in recent versions of Access.
As I recall I did something similar where I made the filters their own sub, and I called a function on the main form to requery things as I desired.
As near as I could tell it was a bug in 2019 that maybe had not been there before; good to know for future that other controls besides list boxes can cause it but gee what a frustrating issue! Glad you found a work around