Forum Discussion

peterbletch's avatar
peterbletch
Copper Contributor
Aug 13, 2024

Filter By Form started crashing Access

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.  
    • peterbletch's avatar
      peterbletch
      Copper Contributor
      Just checked. The build I have is Access® for Microsoft 365 MSO (Version 2407 Build 16.0.17830.20056) 64-bit. Problem still occurring.
    • peterbletch's avatar
      peterbletch
      Copper Contributor
      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.

Resources