Autofill a combo box

O

OM

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

concatenate entries from a column into a cell by logical AND withanother column 2
Combo box 0
combo box data changes based on previous combo box 3
combo boxes do not autofill 0
Combo box should trigger another combo box 2
Synchronize combo boxes 2
Autofil a Text Box 10
sum combo box based on other combo box 2

Top