Hi Irving,

Please provide us with the following so we can help you.

Your Version of Access.
Your Table Name.
The names of the two fields you want to search.
The name of the command button.
The name of the search textbox.
Exactly what you want to do with the results immediately after they
are found.
The name of the Report.

Best Regards,
Patrick Wood
http://gainingaccess.net

End Sub
--- In MS_Access_Professionals@yahoogroups.com, "irving_guy2000"
<irving_guy2000@...> wrote:
>
> 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
>