Filtering a List

  • Thread starter Thread starter Guest
  • Start date Start date
G

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")
 
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
 
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


Jeff Boyce said:
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

Eric said:
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")
Click to expand...
Click to expand...
 
Eric

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

Regards

Jeff Boyce
Microsoft Office/Access MVP

Eric said:
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


Jeff Boyce said:
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

Eric said:
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")
Click to expand...
Click to expand...
Click to expand...
 
Back
Top