I have a form with a filter & remove filter button on it (linked to a query). Even though the On open property of the form & close button on the form are programmed to show all records which it does correctly, the Filter secion of the FORM properties keeps building up as below:
((((((([Report Details].ReportRefPrefix)=[Enter Report Ref Prefix]) AND (([Report Details].ReportRefNo)=[Enter Report Ref No])([Report Details].ReportRefPrefix)=[Enter Report Ref Prefix]) AND (([Report Details].ReportRefNo)=[Enter Report Ref No])))))))
Every time I clear this property and save the form but after I have opened the form, used my filter and then closed the form, it re-appears.
This problem is also occuring with the OrderBy property of the form, this should be blank but keeps getting set to something else.
I have tried every bit of code I know and it's drving me nuts!
Although it's not affecting the records viewed through the form, if these keep building up I am worried they will slow down the response times
((((((([Report Details].ReportRefPrefix)=[Enter Report Ref Prefix]) AND (([Report Details].ReportRefNo)=[Enter Report Ref No])([Report Details].ReportRefPrefix)=[Enter Report Ref Prefix]) AND (([Report Details].ReportRefNo)=[Enter Report Ref No])))))))
Every time I clear this property and save the form but after I have opened the form, used my filter and then closed the form, it re-appears.
This problem is also occuring with the OrderBy property of the form, this should be blank but keeps getting set to something else.
I have tried every bit of code I know and it's drving me nuts!
Although it's not affecting the records viewed through the form, if these keep building up I am worried they will slow down the response times
