I looking for some info on whether what I want to do is possible or not?

I am looking to put together a general search mechanism in my database. What I want to happen is that when the user clicks a command button a text box appears. The user then enters a text string. The resulting query then searches through all text fields in all records and returns those records which contain the entered text string.

I hope this makes sense.
Any help would be very gratefully received.

Thanks

Use:

Like "*" & [Enter Search Criteria]& "*"

as the query criteria.