Filter By Form started crashing Access

[peterbletch]

Issue:  Filter By Form started crashing Access

Causes DB to crash when the function is applied in a Form. ‘Filter in Form’ function does NOT crash when applied to a table.

What I can establish:

• Started in the last few of days. I believe after recent Office update.
• The crash occurs on previous versions of my DB (going back months) which have worked fine until last week
• Did NOT happen with the same DB on a different PC that had the previous version of Office. However after that PC was updated (overnight), the crash started happening.
• Function crashes and does weird stuff in a new template DB (i.e. one pulled from Microsoft Template DB list when you click New in Access. I used the “Time and Billing Template”
• Function does not crash on all DBs I have

Other information

• I do not have any add-ins or VB code in my DBs
• I am using a brand-new Lenovo Yoga PC and a Surface Pro. Same issue on both.  

[#2]

@peterbletch 

The fix for this problem was released. Press the Update Now Button to get the latest update containing the fix. You should get the same version, 2407, build 16.0.17830.20166

Post back, please, to let us know you are successful.

See the article here on AccessForever.org.

[#3]

@George_Hepworth   Many thanks. I will update overnight.

[#4]

Just checked. The build I have is Access® for Microsoft 365 MSO (Version 2407 Build 16.0.17830.20056) 64-bit. Problem still occurring.

[#5]

Just ran another update. Now have build Microsoft® Access® for Microsoft 365 MSO (Version 2407 Build 16.0.17830.20166) 64-bit and this fixed the issue. Many thanks.