Irving-

It would seem that you need a filter something like:

Field1 LIKE "*" & Me.txtSearch & "*"
OR Field2 LIKE "*" & Me.txtSearch & "*"

John Viescas, author
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)


-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of irving_guy2000
Sent: Monday, January 12, 2009 11:01 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Keyword search in MS Access

I've a database with 15 fields with about 5000 records; I want to add
a Keyword search button with a text box to my form which would search
all of 5000 records for the typed-in keyword in 2 of the fields. The
result should be displayed in a report.
Please give me the code to incorporate the keyword search button!

Thank you in advance!

Irving Guy


------------------------------------

Yahoo! Groups Links