I have a button which loads the main search and replace function in access's edit taskbar fucntion (Binoculars).

it works fine but i call it on numerous forms and after a few searches which are performed on different forms users change the search criteria and the next time it is loaded on another form it has that same search criteria as when it was last loaded.

So i wanna know is there a way to edit my existing code which calls it to reset the search criteria (ie:Look In:Field_Name, Match:Whole Field, Search:All) to default values or to any values I choose in the find and replace search box when it is called by a button on a form?

Private Sub Command172_Click()
    DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
End Sub

Thanks to anyone who can help.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Not that I'm aware of. The drawback to using the builtin menuitems is that you end up with builtin behavior. You could build your own Search form, but that can be somewhat time consuming and requires fairly advanced coding in many cases.

And please don't post your question titles in ALL CAPS. It makes reading them difficult, and it's considered shouting (which is rude, according to netiquette).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HudsonMarineAuthor Commented:
I was afraid someone would say that - but thanks anyways and sorry for the caps and for being rude - my bad - Didnt even realize i did that!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.