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.

http://cheekeemonki.angelfire.com/Event_TESTER.accdb

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.

Let me also state that the purpose of this form/query search is for Mail merges and quick reference. The data will not be results will not be stored

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.