creating a search engine

[dbh139]

Does anyone know the best way to create a search engine that allows me to search for any number of fields with a form? Is there a specific type of query that I should use? If anyone could point me in the right direction I would appreciate it. Thanks

 

[Corticus]

Hi dbh139,

Building a 'search form' is a little more complex than it sounds. You typically will need dynamic SQL depending on what fields they want to search on.

BTW, I believe this is called Query by Form.

Check out this file, its an excellent example:
http://www.theillumni.com/httpdocs/posts/multicriteria.zip

Its not my work, but I couldn't find where I got it.

edit:
ah, here we go:
http://www.access-programmers.co.uk...3d40b0&threadid=36145&highlight=multicriteria

Now that's a link!

HTH,