need help in MS Access Search

Hello Everyone,
I need help in MS Access searching,
I need to do something similar to the searching in this link :
http://www.careersearchassoc.com/csearch.asp

I don't need to post my database on the web, I just want my database to search in the way this web is showing, can search multi field for the result.

anyone can help me?

Thanks.

Yeah, you can view their source.

Later,
David Somers

I think u don't understand what I mean.
I'm not creating web.
I want to do searching functions that is similar to the web and is on ms access.

so can u tell me how to view their source and do it into
MS Access format?

Thanks.

Yes you can, all you have to do is the following:
1) Decide how many fields you want to start your search with.

2) build a query with let say whatever number of fields you want to display.
3) create a new fomr with two sections the upper is heading the lower is detail or searching result.

now, for example, let say you want to search for all vehicles with year make 2000 and price is greater than $12000 and color is black.
in the new form you create unbound fields, the first says "Vehicle Make" .......
the second "Price"........
the third "Color"......
then in the query under each related field you put = forms![your new form name]!vehicle make
and the same think with the others.
create push bottun to execute the query then you will see the search result in the lower section of your form.
the lower section should be a subform based on the result of your query.

I still not understand it.
Can you please explain step by step
how it is done?

Thanks.

First create a Form the lists that has a text box that holds all the criteria that you wish to search for.

Second decide if you want the users to enter a * when they want everyting in that category. If you don't then you need to duplicate all the textboxes that you have, make them so that they are not visible, default all of them to load with a * in them. Then write code in each of the orginal textboxes that executes in the after_Update event. The code will check to see if you have entered anything in teh text box, if you have it will transfer this info to the secondary text box, if it is now empty or blank, you will transfer a * to the secondary text box.


Third You will create a query the lists all the information you wish to display for the search, then in the criteria portion you will enter like[Forms]![FormName]![TextBoxName] (change the last two to match your system). The like allows you to use wildcard charcters (for instance * which means anything).

The on your form you will create a command button that will open the query or the report you have tied to the underlying query, when you click it.

Good Luck

S-