Search Facility

[Richie2837]

I've set up a command button on my form in my Contacts database to carry out a search (I used the built-in Wizard).

The command button invokes the Find & Replace function, which works perfectly well, but is there a way of refining it so that the search dialog box opens with "Any Part of Field" selected in the "Match:" criteria, and the whole form rather being selected on the "Look In:" field? Or is there a better (i.e. more fool-proof) way of carrying out a search rather than using the wizard and built-in Find & Replace function? I'm open to suggestions.

I really need to do this so the non-Access clued-up users will be able to carry out a reliable and accurate search without getting themselves in a panic. So far I've had five duplicate people created in my Contacts database because the Search function didn't find the person they were looking for.

 

[Anthony George]

Re search box

Hi

(1) Open your database
(2) Click Tools
(3) Click Options
(4) Click Edit/Find
(5) Check the general search radio button, click OK
(6) Open the search box with your button
(7) In the Look in dropdown select the form name
(8) In the Match dropdown box select Any Part of Field
(9) Close database completely (you must do this)
(10) re-open your database and you should find that access has remembered the settings.

regards

Tony