Autofill Combo box by any word

[lmarconi]

Good morning everyone and Happy New Year!


I have the following problem: in one of my form, i have a sub form with a combo box (named Comment Type) which has as source a list of "reasons" (see example below). The build in auto compile function, allow the user to select and full fill the entire option in the list. Some users asked to have the possibility to see the available entries based on the word they enter in the combo box. Example : if I write "Wrong" i would like to have all "reasons" which "includes" the word "Wrong" not only the first which start with "Wrong" and all rest (normal functionality). Follow is my form. Just for your information, the field Comment Type in the event "After Update" will write the new value if is not available in the list, just to be available next time. Any suggestion ? Thank you

[CJ_London]

nothing attached

[lmarconi]

nothing attached

Sorry, now is attached. So, what i would like to know if it is possible that when i write "Missing" i got all options which include "missing" as word, if not, the system should show all options (like "*"). Thank you

[CJ_London]

use some code in the combo change event to modify the recordset. However you appear to be using a table and tables do not have events, you will need to use a form

the code might be something like

me.cboCommentType.rowsource="SELECT CommentType FROM myTable WHERE CommentType like '*" & cboCommentType.text & "*'"
me.cboCommentType.Dropdown

edit - second line of code added to display the dropdown

[lmarconi]

use some code in the combo change event to modify the recordset. However you appear to be using a table and tables do not have events, you will need to use a form

the code might be something like

me.cboCommentType.rowsource="SELECT CommentType FROM myTable WHERE CommentType like '*" & cboCommentType.text & "*'"
me.cboCommentType.Dropdown

edit - second line of code added to display the dropdown

Thanks a lot, is exactly what i need, much appreciate.