I have a form used to enter items. On the form I have a list box with
items already entered listed, and a few text boxes to enter new items
and info about them. I am trying to filter the list box as I type new
items. into a text box. Each letter entered would filter the listbox
as it is entered.
Example
Enter a and all items starting with a are shown in list box
Enter b and all items starting with ab are shown, etc.

If the Item I'm looking for is not found, ENTER adds what I have typed
into the list.

If it is found I would cancel the entry.

Is this possible?

Thanks for any help.

JackonLI

The functionality you describe can be implemented using VBA code with a List
Box, but it is built-in to the Combo Box control, and I've always thought it
a tremendous waste to re-implement functionality that is included in the
product right out-of-the-box.

Larry Linson, Microsoft Office Access MVP
"Microsoft Access Small Business Solutions", pub by Wiley, 2010
Access Newsgroup: alive and well in comp.databases.ms-access

<JackonLI> wrote

Thanks for the reply. Unfortunately I was looking for a way to do
what I mentioned, not what your opinion is of doing it.


On Mon, 17 Oct 2011 22:47:15 -0600, "Access Developer"
<accdevel (AT) gmail (DOT) com> wrote:

On Oct 19, 10:46*pm, JackonLI wrote:
Google is your friend.

You can set up a dynamic query for the listbox. So create the sql
where clause in-line:

strSQL = "Select FieldName From TableName Where FieldName Like " & "'"
& me.textbox1 & "*'"

Me.Listbox.ControlSource = strSQL

Or maybe it would be RowSource...


Anyway, you put that into the textbox Afterupdate event.

Good luck.

Ah, but why would you bother, since the functionality is built-in to the
Combo Box control?

Larry Linson, Microsoft Office Access MVP

<christianlott1 (AT) yahoo (DOT) com> wrote

You are welcome.

The only reason I can imagine for going to the extra effort to duplicate
functionality that is built-in to one of the Access controls would be if it
were a school assignment, and we are not here to do homework for students.
But surely you aren't a student wanting your homework done.

Good luck, and when you get it done, good luck in your manager not having
found out in the meanwhile that all your effort was unnecessary.

Larry Linson, Microsoft Office Access MVP

<JackonLI> wrote

The functionality is not built into the combobox. A combobox displays
a single line, the listbox displays multiple lines.

Thanks for the link. Looks like I can customize this to my need. ;-)

On Fri, 21 Oct 2011 10:29:37 -0700 (PDT), "christianlott1 (AT) yahoo (DOT) com"
<christianlott1 (AT) yahoo (DOT) com> wrote:

I have seen your name here over the years and I have to believe that
you are an expert in Access. Unfortunately this seems to have given
you an arrogance that I really do not understand.

There is nothing listed in this group or its name that indicates it is
for professionals only. And just because you don't see a "need" to do
something one way, as opposed to another, does not mean it is wrong.

Access is a hobby for me. I enjoy creating databases. Mostly for my
own use, and some for friends. I sometimes spend hours trying to get
something to work. Most of the time I succeed. When I am totally
stumped, since I don't have a "Manager" to ask, I look for help on the
internet, and the Newsgroups.

If you have trouble with this, don't respond to my posts.

Have a great day. ;-)


On Thu, 20 Oct 2011 20:12:52 -0600, "Access Developer"
<accdevel (AT) gmail (DOT) com> wrote: