Autofill a combo box

I realise that combo boxes can be used to "autofill" a value depending on
the first few characters typed, but is it possible to have a combo box (or a
list box I guess) progressively limit the selections, ie. if I have a table
with the following values

Monday
Tuesday
Wednesday
Thursday
Friday
Moms Birthday
Make Money

and in a combo box with its source as the table, what I want is that if I
type "M", then I get a dropdown box with

Moms Birthday
Monday
Make Money

in it. If I then type "o" (so I have "Mo" in the combo) then the list
changes to just

Moms Birthday
Monday

I would then be able to click on either value to select it, or type the next
letter to make the selection, so that "Mom" would give me "Moms Birthday",
but "Mon" would give me "Monday"

Access 2000...

Thanks folk.

Rob Lepper

Allen Browne has an example of this at the following URL ...

http://allenbrowne.com/ser-32.html

--
Brendan Reynolds
Access MVP

"OM" wrote in message
u...
I realise that combo boxes can be used to "autofill" a value depending on
the first few characters typed, but is it possible to have a combo box (or
a list box I guess) progressively limit the selections, ie. if I have a
table with the following values

Monday
Tuesday
Wednesday
Thursday
Friday
Moms Birthday
Make Money

and in a combo box with its source as the table, what I want is that if I
type "M", then I get a dropdown box with

Moms Birthday
Monday
Make Money

in it. If I then type "o" (so I have "Mo" in the combo) then the list
changes to just

Moms Birthday
Monday

I would then be able to click on either value to select it, or type the
next letter to make the selection, so that "Mom" would give me "Moms
Birthday", but "Mon" would give me "Monday"

Access 2000...

Thanks folk.

Rob Lepper