Smart Searching using a combo box

[OzGreg]

Hi

I have a form with a combo box in the header so to search and return results.

It works when I type, but when I click the drop down it displays all the records from that text on-wards.

I would like it to allow me to type the first 3 letters and then display only the search results in the drop down automatically so I can choose which one I want the form to display.

So as I type more letters it displays the appropriate items to choose from for me to select, not all the items only words that have a hit

I would also like it to search anywhere in the field for the text I type

The database is attached for your help

The search term is bearing as there is a limited amount of records

Can someone please help?

Cheers, Greg :banghead:

 

[pbaldy]

Sounds a bit like:

http://allenbrowne.com/ser-32.html

 

[OzGreg]

Hi

Due to the lack of my skill set, I just can't seem to do it.

I get a bit confused with some of what he is saying due to a lack of experience.

Just have to get this sorted and my database in finished.

Can you help out?

 

[jdraw]

I looked at your data. Entering the first 3 characters won't do you much good.

eg: BEA gives 48 result records.

 

[OzGreg]

Hi JDRAW

Thats what I wish to have please.

Cheers, Greg

 

[jdraw]

I created a query and did a Like [first3chars] &"*". When I entered BEA it found 48 records that matched.

I don't use macros.

 

[OzGreg]

Hi

In my macro I have ="[NM_CD_2303] = " & "'" & [Screen].[ActiveControl] & "'"

Anyone know how I can convert JDRAW's Like [first3chars] &"*" to macro speak?

Cheers, Greg

 

[jdraw]

ozgreg,

Watch this video for keyword search info (vba, not macro)

 

[OzGreg]

Thanks JDraw

I have caused a little bit of confusion and am going to re-post my question sorry.

I am wanting to get the combo box to display the multiple search matches in a drop down as I type each letter. Then I select the appropriate one from the drop down to display the details for as a sub-form. Pic attached.

The video you sent was great and its also helped me to word my question a bit better.

Sorry for the confusion, Thanks Greg

 

[jdraw]

Have you considered using the approach in the video?
Since you are searching on one column, you could put the search results on a form or in a listbox as shown in the video.