[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

STRING FOR FIND AND REPLACE SEARCH CRITERIA.

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()
    Screen.PreviousControl.SetFocus
    DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
End Sub

Thanks to anyone who can help.

0
HudsonMarine
Asked:
HudsonMarine
1 Solution
 
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).
0
 
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!
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now