Listbox Autofilter.

Doug

Guest

Posts: n/a

25th May 2004

Hi Folks - as I enter text in a listbox, I would like it
to automatically provide a list of possible options
matching the wildcard that I have entered. Exactly the
same as when you type an object name followed by a . and
the list appears. Can any provide an assistance with this
or a link to an article? So far I've been using the
keypressed event and setting up a a peice of SQL based on
the value entered, but I think I'm on the wrong path.
Thank you.

« Question to Access runtime environment | Manual Auto Number »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Printing Sections of Worksheet Using AutoFilter and ListBox Values	RyanH	Microsoft Excel Programming	2	18th Oct 2008 12:33 AM
Pass listbox values to autofilter	Ixtreme	Microsoft Excel Programming	5	25th Aug 2007 02:45 PM
Autofilter and Listbox how to acomplish?	jose luis	Microsoft Excel Programming	6	28th Jun 2005 08:06 PM
AutoFilter _FilterDatabase Rowsource Listbox	hgdev	Microsoft Excel Programming	4	5th Mar 2004 04:39 AM
Values missing in Autofilter listbox	Igors Belijs	Microsoft Excel Worksheet Functions	1	30th Oct 2003 11:06 AM