UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Progressively Filter a Listbox by a Textbox    
 
   
niesz
post Dec 22 2009, 04:11 PM
Post#1


Utter A-fishin'-ado
Posts: 17,958
Joined: 1-August 05
From: Cincinnati, Ohio, USA . . . ><((((°>


I have found this filtering technique very useful from time to time. Perhaps you will, too.
xample: Your listbox contains several hundred entries. You want to type in the first few letters of what you're looking for to narrow down your selection.
This example will show you how to use the OnChange event and build a SQL string dynamically to reassign the listbox rowsource.
There is both an ACC2007 and ACC2000 version attached.
Enjoy!
Attached File(s)
Attached File  FilterBy.zip ( 63.37K )Number of downloads: 901
 
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    13th December 2017 - 03:57 PM