Filtering a List

[Guest]

I have created a list box (of students A-Z) linked to a query that refreshes
on KeyUp. This effectively reduces the list based on what letter (or 2
letters with fast fingers) that I type into a field I use as a filter. How
can I modify that filter so that I can type more letters in the field and get
a shorter list? (ie: "smi" would show a list of all students with a [last
name] starting with "smi")

 

[Jeff Boyce]

Eric

The combobox has a property that lets you type more characters in and zero's
in as you've described. Is that a possibility?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

It sounds like it would. I just don't know which property to change. I have
the list pointed to a query that Refreshes on KeyUp from the combo box. Am I
working too hard on something that's simple?
--
Eric

Eric

The combobox has a property that lets you type more characters in and zero's
in as you've described. Is that a possibility?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have created a list box (of students A-Z) linked to a query that
refreshes
on KeyUp. This effectively reduces the list based on what letter (or 2
letters with fast fingers) that I type into a field I use as a filter. How
can I modify that filter so that I can type more letters in the field and
get
a shorter list? (ie: "smi" would show a list of all students with a [last
name] starting with "smi")

 

[Jeff Boyce]

Eric

Yes. Take a look at Access HELP for the NotInList event. No KeyUp
required...

Regards

Jeff Boyce
Microsoft Office/Access MVP

It sounds like it would. I just don't know which property to change. I
have
the list pointed to a query that Refreshes on KeyUp from the combo box. Am
I
working too hard on something that's simple?
--
Eric

Eric

The combobox has a property that lets you type more characters in and
zero's
in as you've described. Is that a possibility?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have created a list box (of students A-Z) linked to a query that
refreshes
on KeyUp. This effectively reduces the list based on what letter (or 2
letters with fast fingers) that I type into a field I use as a filter.
How
can I modify that filter so that I can type more letters in the field
and
get
a shorter list? (ie: "smi" would show a list of all students with a
[last
name] starting with "smi")