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    
post Dec 22 2009, 04:11 PM

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.
Attached File(s)
Attached File  FilterBy.zip ( 63.37K )Number of downloads: 928
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    19th August 2019 - 06:00 AM