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]
Tidak ada komentar:
Posting Komentar