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?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor 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).
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!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.