By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,163 Members | 976 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,163 IT Pros & Developers. It's quick & easy.

Button Sequence?

P: n/a
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?

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <ra****@msn.com> wrote in message
news:11*********************@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?
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.