Hi All,
I have a user that developed a database where one of his forms has the ability to filter checks using a macro. He has placed this macro on the double click event of the check number label. After upgrading to Access 2000 from Access 97 his filter does not refresh or clear itself so he can only filter once. I have found that we can add the close form and OpenForm function at the beginning of the macro to clear out the filter but there has to be a better way. Any suggestions?
Thank you!
Sandy
I have a user that developed a database where one of his forms has the ability to filter checks using a macro. He has placed this macro on the double click event of the check number label. After upgrading to Access 2000 from Access 97 his filter does not refresh or clear itself so he can only filter once. I have found that we can add the close form and OpenForm function at the beginning of the macro to clear out the filter but there has to be a better way. Any suggestions?
Thank you!
Sandy