i used the "command button wizard" to build the following - it applies a filter based on the selection. this button is on my form "ReadFrm"
i need to be able to remove the filter as well. I would like to be able to apply the filter with the first click and then remove the filter with the second click???????? or at least add a second button to remove the filter. (nothing in the "command button wizard" on removing the filter????
Private Sub Command97_Click()
On Error GoTo Err_Command97_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 2, , acMenuVer70