filters stop working

B

bulldoggrace

I installed service pack 1a for access 2000 and now my
filters don't work. I have a form with a command button
that runs a macro to filter the form.

the macro is an applyfilter with a condtion set to [acct
number]=[enter acct number]

the first time I click on the command button the macro
runs and filters the form by my selection. The second
time I click nothing happens. If I show all records or
remove the filter all records appear. Now when I click
on the command button again it filters by the original
selections and now longer asks for an acct number.

Dose anyone know how to fix this or if service pack 2 and
3 will reslove this issue.

Any suggestions are greatly appreciated.

Thank you
 
Top