So I was working on an access database and I wanted to implement a search box that updates a subform dynamically as the user enters text. I searched online a lot and all i found was made using really ugly VBA code to set a search filter manually. I will show you how to do this using two VBA lines , a temp variable and a query. ENJOOYYY!!
Nothing fancy here, i just make a query showing all results unfiltered , typically what you would have if the search box has nothing in it.
The Trick here : I depend on the tempvars which is an access structure that holds temporary variables.