Hello Cetin:

** I am glad everything is OK with you and your family, concerning the car accident. That is certainly good news.


Also, thanks for your help with clearing my combo boxes. Your note was very helpful.

> I have another question regarding my search form. I have spent the last two weeks getting my combo boxes to work correclty, and I am proud to say they finally are working the way I intended for them to work! Now that they are pulling the correct data, I need for the user to be able to "fetch" what they "searched" for.

The search form has 6 combo boxes:

1. Country
2. State
3. County
4. Locality
5. District
6. Office Title

The whole purpose of the search form is for the user to find a specific political office, anywhere in the world! For the time being it is just pulling data from 2 states, but in the future it will be global.

The last three combo boxes (#4, #5, #6), indicate a specific office.

Example, the user may select:

1. USA
2. Florida
3. Dade
4. Miami
5. 56
6. City Commissioner


Miami, 56, & City Commissioner indicate the specific office the user is looking for. I have an OFFICES form (which is storing its data in an offices table) that is holding that specific office.

*** GOAL ***
I would like to have the user press a command button called GO (on my search form), and have my OFFICE form pop up with the record of that specific office (Miami, 56, City Commisssioner) showing.

What is the best way to go about doing this proceedure?

My specific concern is how to call the correct record in my OFFICES form when I am not referring to a specific id number. I am trying to match text from 3 combo boxes on my search form, to 2 combo boxes and 1 textbox on my OFFICES form, that are holding the exact same information. Is this possible?

If you have any ideas, I would sure like to hear them.

TIA

Jason