create simple search

**Armitage2k** · 09-27-2009, 02:57 AM

Hello!

I have a table ("Contacts") with the columns last name, first name, CRS and now I would like to create a simple search. the search form should have the 3 textboxes for data input of each column (1 box for last name, 1 box for first name and one for the CRS notes) and then show me the results below in a list. Once an entry is selected/double clicked I want to open a form called "VIP" with this entry's details. i have a screenshot of how that should look.

Now, since I am total access n00b, I honestly have now clue on how to even start this. I looked out for some simple searches which more or less come close to my needs, but either they are too expensive or just not explained in a tutorial. If someone could help me to code this or maybe provide me with a link to a SIMPLE tutorial on how to create a search for one table in a MDB database, I would highly appreciate it!

Thanks a lot to all of you!
A2k

**JethroUK** · 09-27-2009, 03:28 AM

Look at Access built-in feature 'filter by form'

**split_atom18** · 09-28-2009, 09:42 AM

What version of access are you using?

It is a lot easier with TempVars in 2007.

There is a 2007 Template called Contact Management Database that is available to download and show you how to accomplish what you are looking for.

If you can't figure out a better way, then make a query to open another form that takes input for the query filtering from the 3 boxes you made.

Hope this helps,

Dan