foolproof find

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for a foolproof, 1-click way to search for a single word within
any field and record, without having to alter the "Look In" and "Match"
fields of the Find dialog box.

I find that infrequent users give up when they attempt to search for a
record and draw a blank.

Can anyone help?
 
I am looking for a foolproof, 1-click way to search for a single word within
any field and record, without having to alter the "Look In" and "Match"
fields of the Find dialog box.

I find that infrequent users give up when they attempt to search for a
record and draw a blank.

Can anyone help?
Click to expand...

You'll need to open a Query: create a query based on your table with a
criterion

LIKE "*" & [Forms]![yourform]![yourtextbox] & "*"

using the name of your form and an *UNBOUND* textbox on the form.

Put this criterion on a different row under each field in your table.

You can use this query in a few different ways - simplest would be to
set the Form's Recordsource property to the query.

I'm VERY PUZZLED why you would *ever* want to do this though; in a
rationally designed table, each field is a different attribute of an
entity. It would make no sense to search a Zipcode field for a
LastName or vice versa. Could you explain why this very odd search is
necessary?

John W. Vinson[MVP]
 
Back
Top