Combo Box keyword search

[jhergert]

Hi,



I am extremely new to access. I am trying to help out my employer with putting together a simple database. I would like to have a keyword search as you type combo box. But I don’t know how to code it. Any suggestions would be much appreciated

Thank you.

[June7]

Fairly common topic. Review http://allenbrowne.com/ser-32.html

And https://stackoverflow.com/questions/...ccess-combobox

Basically, set combobox RowSource property with each typed character by code in combobox Change event.

[jhergert]

Thank you June7

Would this same concept work if my combo box is referencing a query?

[June7]

Yes. Give it a try and let us know if there is particular issue.

[Welshgasman]

You can also use a class.

https://www.access-programmers.co.uk...x-form.327863/