Re: [MS_AccessPros] Populate ListBox

Dear John,

I want to share a link with you, in this link is what I want to working
around but with simple code let only onChange Event do all the work, kindly
clear me about that if its possible.

http://www.opengatesw.net/ms-access-tutorials/Access-Articles/Search-As-You-Type-Access.html


On Tue, May 15, 2012 at 11:44 PM, John Viescas <JohnV@msn.com> wrote:

> **
>
>
> Abdul-
>
> Make the List Box a Value List, and use the .AddItem method of the List Box
> control to put additional entries in the list. You probably want to use the
> After Update event of the text box. If you use On Change, that event fires
> for
> each character typed or erased. For example, if the user types
> "Abercrombie",
> the list box will contain all items:
>
> Like "A*"
>
> Like "Ab*"
>
> Like "Abe*"
>
> Like "Aber*"
>
> . and so on.
>
> John Viescas, author
>
> Microsoft Office Access 2010 Inside Out
>
> Microsoft Office Access 2007 Inside Out
>
> Building Microsoft Access Applications
>
> Microsoft Office Access 2003 Inside Out
>
> SQL Queries for Mere Mortals
>
> <http://www.viescas.com/> http://www.viescas.com/
>
> (Paris, France)
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Abdul
> Shakeel
> Sent: Tuesday, May 15, 2012 8:08 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Populate ListBox
>
>
> Dear All
>
> I want to populate a unbound listbox from an unbound textbox onChange
> event, both the controls are on same form, the list box contains product
> name & I want when user enters any word in the text box the listbox
> required with the word entered in the textbox using LIKE statement.
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/