Dynamically search multiple fields. Two unbound listboxes

[neideb]

Hi All,
I decided to start a new thread because I could not find a solution in the previous one.
First of all I thank Joe for his SearchFor, SearchResults sample he offers for this community. It is really the best.
I am using the refered code to search for Name of Exams based on QrySearchAll.
I wish I could create in the same form another listbox to select Name of Hospitals. It is not a sincronized list. I wish to search first for the NameOfExam, select by click, keep this name of Exam in the field text then search for NameOfHospitals, click and keep this second item in another field.
Then create a button to go to a newrecord in a subform and update the table with those selected names plus some other fields I have to fill.
I have this working with two comboboxes but I wish I could use the Dynamically search multiple fields because I can see names clearly in a listbox.
I hope you can help me on this. If you wish I can send you a sample of my database.
Tks a lot.

 

[neideb]

Hi, I am stuck on this and begging for help. Maybe someone has another idea and will be welcome.
Tks

 

[CBrighton]

Have a look at this thread, it has info on creating search forms: http://www.access-programmers.co.uk/forums/showthread.php?t=188663

:edit:

Just realised, I think that's what you have already done. My bad!

 

[neideb]

Tks Brighton, yes I have already seen that code. What I need is to search in the same form two different sources to populate another form all at once.
The reason of trying to use the code is to see the names all together. Also to use de (*) to find any part of field that I could not do in comboboxes.
Tks again

 

[neideb]

Tks to all. I have already found the solution to my problem. I created a pop-up list form that I call from my form. I search for name I want then double click and the result is saved in the form.
If anyone needs help feel free to send me email or post here.

 

[accessfever]

I have an Access Database that I wanted to be the similiar search like yours. If you could share the codes that you come up with the solution in the Forum, that would be great.

 

[neideb]

Hi, accessfever, I will prepare a sample to post in forum.

 

[neideb]

Hi Accessfever, hope this still helps you.
I am attaching a sample of what I am using based on code that John Big Booty provided us.
Maybe you will have problems to populate ExamID and Examname after double click the ExamName list.
Hope this helps. Feel free to post back.