Keyword Search on a Form

[tarasios]

I have searched the archives and the answers don't quite seem to fit
what I am trying.



I have a form that displays information (text boxes and 2 memo fields),
including combo boxes which pull info from seperate tables, i.e. product
type, etc.



I'd like to enable the user to search all the text fields in the
database using a text field and button - go, search, etc.. Then
display all results - like a web search. And display the results as a
"link" so the user can click on it and be taken to the appropriate
record in the form. Later I'd like to be able to include the combo box
tables in the search.



I have played with it for awhile but can't seem to get anything to work.
Any ideas? Thanks.

 

[tarasios]

Sorry, the data is currenty in one table. There are also what I call
reference tables that hold the combo box information - these are all
displayed on one form by project_id, the primary id of the main table.



It is a pretty small, simple database to track certain project
information. There are 11 reference tables each with a one-to-many
relationship with the main table.



I have been able to come up with a keyword search that searches at all
the text and memo fields in the main table and produces the results (a
datasheet row) - done with SQL. It searches for wildcard'user-entered
text'wildcard. However, it's of no use to the user if he can't go
directly to the record in the main form. That's all they want to do for
now - click the result and look at the record.



So I'm looking for a way to display the results in maybe a new form in a
hyperlink-type format. Clicking it would take them to the record in the
main form. Or if there's something easier...



Hope this clears it up a bit. Thanks.



-Dale

 

[tarasios]

It seems I needed to do a little more. However, I found a great example
that fits my needs. Though I used a search that searches all text
fields, not just ones specified in a form. See the following link and
scroll down to user 'Beef'. The attached example is easily
customizable. Thanks for your help.



http://www.accessvba.com/showthread.php?threadid=3998&highlight=SEARC-
H+DATABASE