In my database, I have a table called TopicTable. This has a many-to-many relationship to a table called TagTable. Each Topic can have multiple Tags, and these Tags can also be used for multiple Topics.

I have created a data entry form for TopicTable (TopicSingleForm) which contains a subform (TopicTagSubform) with a Combo Box (TagCombo) so people can choose multiple tags from the 30 or so available.

The TopicTagSubform is powered by a simple query.  

I have managed to create "Filter as you type" Combo Boxes in other parts of my database, but those are purely for "single entry" fields, and not fields where multiple entries can be added.

When I enter the Combo Box in the subform embedded on the TopicSingleForm data entry page, the list appears as it should, and when I type into the field, it shows the appropriate entries. I select one. But when I go to the next record in the subform to add a second Tag, the only dropdown entry remaining in the list is the one above that I have just selected.

I'm sure there's a way to clear the dropdown in the subform, so another record can be added, but I just don't know what that is.

My code is:

Private Sub TagCombo_Change()

    TagCombo.RowSource = "SELECT [TagTable].[TagName] " & _
        "FROM TagTable " & _
        "WHERE TagName Like ""*" & TagCombo.Text & "*"" " & _
        "ORDER BY [TagName];"
    SMESearch.Dropdown

End Sub

Thanks a million :)