I'm asked to create a big searchpage with 13 options to search on.
There also are 3 between options (each between uses two formfields) and have to search one column each.

And an option to to enter keywords which can search in whole table.

Is there a way that achieves the 13 search option page without having to type in all the "AND's" and "OR's" for each search option possible??

Hope someone can help.


www.mazdavandenakker.nl/occasions/search/search.asp

Take a look at: www.tdsf.co.uk/tdsfdemo/

To be honest, I've improved on the search I've created in the tutorial a fair bit, but it might give you a few ideas.

Regards

Owen.

-------------------------------------------------------------------------------------------
Used programming books and web development software for sale (UK only): www.tdsf.co.uk/tdsfdemo/Shop.htm

Developer services and tutorials: www.drdev.net

Multiple Parameter UD4 / Access 2000 Search Tutorial: www.tdsf.co.uk/tdsfdemo/

Thanks Owen I will take a look.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I'm asked to create a big searchpage with 13 options to search on.
There also are 3 between options (each between uses two formfields) and have to search one column each.

And an option to to enter keywords which can search in whole table.

Is there a way that achieves the 13 search option page without having to type in all the "AND's" and "OR's" for each search option possible??

Hope someone can help.


www.mazdavandenakker.nl/occasions/search/search.asp
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Edited by - jellejacob on 19 Jun 2003 17:02:04

What can array's do in this matter?