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?
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?