Search Engine

[Scott Matheny]

I need a way for users to search through my database but
to really be able to do so effectively, the way an
advanced search engine would allow. Can anyone with
experience really give me some directive in how to go
about building an effective way to search through
records. Please be aware that I also have a complex table
relation that needs to jive with this search, meaning I
need to be able to search through multiple sub-forms
simulntaneously.

Thanks in advance,
-Scott M.

 

[John Nurick]

Hi Scott,

Basically the idea is to create a search form where the user can enter
the search criteria, with code behind it that builds a SQL statement
that implements what the user has specified.

A good starting point is the generic search form here:
http://www.mvps.org/access/forms/frm0045.htm