Solved Search as you type with in Combobox / instant filter combobox itself (1 Viewer)

Linda1503

Member
Local time
Today, 11:36
Joined
Sep 3, 2021
Messages
77
here test your db using your
FilterComboAsYouType() function.
Hi @arnelgp
Could I use that code on an unbound combo box with horribly messy row source: SELECT DISTINCT TypesAll.TypesAllID, [Type] & " " & [SubType] AS FullType FROM (TSub INNER JOIN (T1 INNER JOIN TypesAll ON T1.TypeID = TypesAll.TypeID) ON TSub.ID = TypesAll.SubID) INNER JOIN Product ON TypesAll.TypesAllID=Product.[FullType]; ?
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 07:36
Joined
May 21, 2018
Messages
8,463
The one I posted will as long as it does not use parameters, but I think @arnelgp will as well since both are putting a filter on top of the existing query.
 

Linda1503

Member
Local time
Today, 11:36
Joined
Sep 3, 2021
Messages
77
Thank you - useful!
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 07:36
Joined
May 21, 2018
Messages
8,463
I probably should have said that differently. It is not a "filter" but adding a where clause.
Asume you have some really long complex sql query.
"Select Field1, Field2 ......."
so basically you wrap that query instead of modifying it.
Select * from (Select Field1, Field2 ......) Where somecriteria.
 

Users who are viewing this thread

Top Bottom