How do you Create a Search Function?

[J1mmy]

Hello

I have created a database called Contacts Database, and inside this database there are three tables, one called contacts, one called business and one called accounts.

I want to try and make a search function so you can look for anyone in the contacts field and all their details appear.

I originally made a seperate form and placed a combo box in it so that you could look for peoples details that way. But it doesn't deliver the right depth of information. I would like it so that you could click on the person who you have looked up and then you are taken to a new form with all their details on. But i'm not sure if thats possible.

Do you know any other way I can search for a contact by typing in their name (either forename or surname) and then clicking search or something like that to have all their details appear.

I also have a form called Edit Contacts, and this shows everyones details but because there are so many it could take a while to scroll to someone near the end, is there anyway I could work something on this form?

Thanks in advance

 

[SpiritedAway]

If you open access 2007 - download sample templates - there's one called contact management - which has a search function -

Go to design view and looked at the macros behind the "searchgo" and "searchclear" buttons -

You can import them into your own database and customise as you see fit.

If you're using earlier versions of Access - you can download compatible versions from the Microsoft access template site.

 

[John Big Booty]

Perhaps the sample posted here is the sort of thing you are after.