keyword search in Access

[lavesely]

What I want to do is kina like adding the [Enter Number] function on a query.
It prompts the user to search based on a number.

This is what I want to do:
Retrieve record(s) based on a Keyword entry. This search would allow the
user to enter a keyword that would search all records and fields within a
table and display all results.

Say a fruit databse table and we have one combo box, pulled from a table
that lets you select all varities and then another field that you enter in
all text pertaining to a specific issue. Whether the keyword the user enters
when prompted the results will be all records containing the keyword no
matter what field it's in. Is there away to do this?

 

[Jeff Boyce]

It seems somewhat contrary to the notion of relational design to have to
search "all ... fields" to match a search value/string. If a database is
well-normalized, the string/value being sought would probably only be stored
in a single field.

If your database structure is more like what you'd see in a spreadsheet, the
tools and features of Access won't work as well on it.