Thanks. I have created various popup forms and one in particular come up blank. If I leave that form open but click the command button again then the fields and data appear but not the first time. Any ideas how I can fix this? Nikki "Tom Wickerath" wrote: > Hi Nikki, > > Yes, you can do this, but in order to do it as you type, you would need to > use the Keypress event. This would be a very "chatty" application which, if > ever put on a network and shared with multiple users, would likely be > unacceptably slow. My suggestion is to have a command button that would > perform the search only after you entered the desired search term. That way, > it would not retrieve different recordsets for each keystroke, as in: > > S ---> Recordset 1 > Su ---> Recordset 2 > Sup ---> Recordset 3 > Supe ---> Recordset 4 > Super ---> Recordset 5 > > An idea that is similar is shown in this article: > > Access Cookbook > Chapter 8 Excerpt: Make Slow Forms Run Faster > > http://msdn.microsoft.com/library/d.../en-us/dnacbk02/html/ODC_CookbookChapter8.asp > > Look for the section titled: "Combo and list box controls". > > > Tom Wickerath, Microsoft Access MVP > > http://www.access.qbuilt.com/html/expert_contributors.html > http://www.access.qbuilt.com/html/search.html > __________________________________________ > > "Nikki" wrote: > > > Is there a way that I can make access filter down a list of records as I > > type? > > Like if I typed 'super' it would bring up everything that has super at the > > beginning, but as I continued to type 'supermarket' it would only show the > > ones with supermarket at the beginning.