Any help is greatly appreciated!!!!

I have already created a dialog box that holds the Combobox that contains the list of searchable terms but I am getting stuck on my search/go button.

Here is a link to a copy of the DB Event Search form in question.

I have listed the sample fields as Event 1 - Event 6.

The query "EVENT SEARCH" contains combined data from two forms that I would like to search.

In the test db I have two names in the drop down menu... Ron Pressman and Jack Touble... The combobox search should only pull up the records that contain the selected name in any of the 6 event fields.

Thanks again for any help with this issue.