Robust Search Function in Access

[John Big Booty]

You could put a search button on the form.

You could either use the button to dump a sting into the search field, or move the code to the button's On Click event. Either way you would need to make some changes to the code involved.

As I'm currently on the road, and don't have access to Access I can't really elaborate on what those changes might be.

 

[davies107]

You could put a search button on the form.

You could either use the button to dump a sting into the search field, or move the code to the button's On Click event. Either way you would need to make some changes to the code involved.

As I'm currently on the road, and don't have access to Access I can't really elaborate on what those changes might be.

thanks John. will try this right now and let you know how it goes.

 

[davies107]

I tried what you suggested John but nothing happens. I moved the codes into the Search Button that I created but it wont search anything. I know theres some codes I missed which i dont know, i tried but nothing happens still. I am doing this to lessen the slow searching in every key stroke that start searching, do you think this is possible? having a search button?

i am thinking of another solution - a combobox, like the combobox has choices - Australia, Italy, etc (countries in your database), then once the country is choosen it will give results according to what the user pick then items will be listed in the listbox then thats the time the users will type in the Search Box. it will lessen the slow down because data/results are narrowed down by countries.

which one is simplier? or advisable?