HELP! How do I search 6 fields with one combobox

Reply

Join Date: May 2009
Posts: 2
Reputation: cheekeemonki is an unknown quantity at this point 
Solved Threads: 0
cheekeemonki cheekeemonki is offline Offline
Newbie Poster

HELP! How do I search 6 fields with one combobox

 
0
  #1
May 3rd, 2009
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.
Reply With Quote Quick reply to this message  
Join Date: May 2009
Posts: 2
Reputation: cheekeemonki is an unknown quantity at this point 
Solved Threads: 0
cheekeemonki cheekeemonki is offline Offline
Newbie Poster

Re: HELP! How do I search 6 fields with one combobox

 
0
  #2
May 4th, 2009
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
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC