![]() ![]() ** Kindly reply to this message if this solves your problem. ![]() The first picture shows the default values, second picture shows changed values and the third picture shows the message if values are edited. See the below given pictures for more clarity. This is my Function I use to do filter combo-box as typed: Public Sub FilterComboAsYouType(combo As ComboBox, defaultSQL As String, lookupField As String) Dim strSQL As String If Len(combo.Text) > 0 Then strSQL defaultSQL & ' WHERE ' & lookupField & ' LIKE '' & combo.Text & ''' Else strSQL defaultSQL 'This is the default row source of combo box End If combo.RowSource strSQL combo.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |