I can set up a button to run an OpenForm with a query through a macro
and everything runs fine until I click on the button again to do
another query from the same button. It does not work the second time.
If I click on Remove Filter all the records show again. Then if I
click on the button again the first set of records will come up from
the first time I clicked the button.

What do I need to correct?

you could add "docmd.showallrecords" before the code on your command button
so that it removes any filter before it applies a new one.


"Randy" <ranmcc@msn.com> wrote in message
news:1113596620.755216.14000@o13g2000cwo.googlegro ups.com...
I can set up a button to run an OpenForm with a query through a macro
and everything runs fine until I click on the button again to do
another query from the same button. It does not work the second time.
If I click on Remove Filter all the records show again. Then if I
click on the button again the first set of records will come up from
the first time I clicked the button.

What do I need to correct?