Finding a string

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

I am relatively new to Access programming so please be patient. I have a
table (Tbl_Test) with 5 fields. I want to search for an enter word (inputbox
will do) which could be in any one of the 5 fields.

Can someone please advise how to produce a msgbox the says the entered word
was found in field x. Actually even better I would prefer to product a
datasheet-view-query that would show all of the table headings and all fields
in that found record(s).

Andrew B






--
Andrew
.

Relevant Pages