Re: Llimit Listbox from Textbox dynamically

On Oct 21, 4:04 pm, JackonLI 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"







<accde...@xxxxxxxxx> 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 in message
news:ja6v97lkguks6leblintogoo28pqok1j48@xxxxxxxxxx
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"
<accde...@xxxxxxxxx> wrote:

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 in message
news:og9p97tupi03dckcsc99c9l3a6jb50u14c@xxxxxxxxxx
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

Are you known as "Petulant Baby" at work?
.

Relevant Pages