Posted on 2008-11-19
Last Modified: 2013-11-29
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.

Question by:HudsonMarine
    LVL 84

    Accepted Solution

    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).
    LVL 1

    Author Comment

    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!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now