B
BeenPuzzled44
My preferred way to filter records is using the DoCmd.ApplyFilter in the
OnClick property of a command button on a form. In Access 97 I could click
on my command button multiple times and it would reapply my filter query each
time. However, in Access 2000 and above it will only let me apply the filter
once, at least when I enter the query parameter criteria when the query asks
for it. Is this possible in Access 2000 and above to do this without either
removing the filter or closing and re-opening the form before reapplying the
filter query?
OnClick property of a command button on a form. In Access 97 I could click
on my command button multiple times and it would reapply my filter query each
time. However, in Access 2000 and above it will only let me apply the filter
once, at least when I enter the query parameter criteria when the query asks
for it. Is this possible in Access 2000 and above to do this without either
removing the filter or closing and re-opening the form before reapplying the
filter query?