Gets very close to what I am looking for. I will take a bit of modification
but I think that I can make it work.

Thanks

"Golfinray" wrote:

The standard form filter is:
Me.filter = "[youridfield] = """ & Me.combo# & """"
Me.filteron=true
Then check with Allen Browne at www.allenbrowne.com to get the search as you
type part.

"John F" wrote:

What I want to create is a dynamic filter that will narrow down your choices
as you type in a combo box.

I.E. The selection narrows as you type "a" will display all that starts with
"a".
Continue to type "ab" displays all that start with "ab" then by the time you
have typed "aba" you may now only have 3 or 4 choices to choose from and
clicking one will bring up that record for viewing or modification.

I have seen it done in web based database front ends. Is there a way to do
this from a form control?