Filter Button Not Working

[Tophan]

Hello,

I have a database that I have been using for the past 2 years which from this week has started giving some trouble. In the main form there are different categories which before I would use the filter button on the ribbon to narrow searches within a category.

However, from this week, whenever I click the filter button it clears all the data that has been entered and I have to close the form and reopen it for the data to reappear and then search manually by scrolling through the records.

I have tried compressing and repairing but the problem continues.

Any ideas what might be the cause and how it can be fixed?

 

[theDBguy]

Maybe it's an update bug. Do you know if you just upgraded your version?

 

[June7]

Something must have changed. Software update?

Does this happen with all db files? Does it happen with this file on another computer?

Doesn't sound like issue with specific file but the Access app. Maybe uninstall/reinstall.

Want to provide your db for analysis?

 

[Tophan]

Maybe it's an update bug. Do you know if you just upgraded your version?

Maybe it's an update bug. Do you know if you just upgraded your version?

Maybe it's an update bug. Do you know if you just upgraded your version?

Hi. Actually there was an update recently, can't remember the exact date, but it was either last week or week before.

 

[Tophan]

Something must have changed. Software update?

Does this happen with all db files? Does it happen with this file on another computer?

Doesn't sound like issue with specific file but the Access app. Maybe uninstall/reinstall.

Want to provide your db for analysis?

Hi. This is the main db I work in, the other one I am only now building it so I haven't noticed any issues...yet.

I think as theDBguy said it is probably a system update issue.

Is there a way to restore the previous version of access only?

 

[June7]

A Windows update would not update Access.

 

[Tophan]

A Windows update would not update Access.

It wasn't a windows update, it was an Office 365 update

 

[June7]

Oh, okay. I don't use Office365. Does this help https://support.microsoft.com/en-us...f-office-2bd5c457-a917-d57e-35a1-f709e3dda841

 

[Tophan]

Thank you! When I check the version history I see there was an update on April 11th which is probably what caused the issue; and an update on April 25th. I just did the April 25th update hoping it was a bug fix but no luck. So I will try restoring the version before April 11th to see if that works.

Thanks again!