Shorten Combo Box List To Make it Easy For Users to Select Data

[satifali]

Hi,
I am trying to shorten the list of combo-box items in Ms-Access 2010. I have a combo box type on my form which is linked to another table which has 3000 records. I m trying when user gets to combo box & enters part of text it filters up the list to given text if it exists in any part of available data.

Appreciate you help.

[ADezii]

I created a Demo for you that illustrates the technique that I use to Limit Combo Box Items. I create a Text Box immediately above the Combo Box into which Search Strings can be entered. For this Demo I have a Table consisting of 50,000+ Zip Codes along with associated Data. Entering a digit(s) into the Text Box Limits the Row Source of the Combo Box to ZIP*, e.g. 123*, 99*, 847*, 4*, etc. In this case a Picture is worth a thousand words, so instead of pasting the Code, I'll simply Upload a small Demo for you. Hope this helps.

[satifali]

Thanks ADezii, This Works.

[ADezii]

You are quite welcome.