Please provide more details.
Can you explain the structure of your table, and maybe five an example of what you would be looking for?
It sounds like it is possible that you have some table design issues if you are trying to do something like this.
Table is created from data imported from outlook.
The Fields are "to", "from", "subject line", "date","message", 'received", "attachment" and "ID".
I would like to do a search in the table where, for example, search wherever the text of "BR234" or maybe "James" appears in the table. These items could be found in any columns/fields in the table. I would like to create a form where the search command and be executed.
Do you know how to create a search form to search a single column?
If so, what method are you using?
If you are using the method that you are using the form to build SQL or criteria on the fly, you just to need to add to it to search every possible column, i.e. instead of having criteria like: [Field1]="br214"
you would have something like: [Field1]="br214" or [Field2]="br214" or [Field3]="br214" or ...
I am not sure which method they are using (I don't have time to watch the 10 minute video right now), but the way I do is to use VBA to build the necessary SQL code "on-the-fly". Here is an example of one I have done in the past: http://www.mrexcel.com/forum/showpost.php?p=1619906
If you search the Access forum for threads with "Search Form" in the title, you will find many more threads on this topic.