How to make 'Autocomplete' Boxes that are not limited to a list?

[Jack G]

I would like to have a text box that autocompletes itself and fills in
several other text boxes in the same manner that the Northwinds sample works
for Customer Names in the Orders form. But in my case I've had over 1000
total "Customers" of which only about 50 are used on any regular basis at
all. And we frequently add names that haven't been used before. So I'd
like to set it up so that Access recognizes the 50 or so names available for
autocomplete, but if it's something new it would let me go ahead and enter
the full information (sorta like Excel autocompletes but accepts new phrases
as well).

I tried changing the "Limit to List" property in the Northwinds sample, but
that pretty much broke everything, so that didn't look the way to go.

Can anyone point me in the right direction?

Jack

 

[RuralGuy]

I would like to have a text box that autocompletes itself and fills in
several other text boxes in the same manner that the Northwinds sample works
for Customer Names in the Orders form. But in my case I've had over 1000
total "Customers" of which only about 50 are used on any regular basis at
all. And we frequently add names that haven't been used before. So I'd
like to set it up so that Access recognizes the 50 or so names available for
autocomplete, but if it's something new it would let me go ahead and enter
the full information (sorta like Excel autocompletes but accepts new phrases
as well).

I tried changing the "Limit to List" property in the Northwinds sample, but
that pretty much broke everything, so that didn't look the way to go.

Can anyone point me in the right direction?

Jack

Hi Jack,
Here's a couple of links you might find useful.

Mastering the Combo Box NotInList Event
http://www.fontstuff.com/access/acctut20.htm

Combos with Tens of Thousands of Records
http://allenbrowne.com/ser-32.html

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Jack G]

Thanks RG, I'll check these out.

Jack

Hi Jack,
Here's a couple of links you might find useful.

Mastering the Combo Box NotInList Event
http://www.fontstuff.com/access/acctut20.htm

Combos with Tens of Thousands of Records
http://allenbrowne.com/ser-32.html

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[RuralGuy]

Thanks RG, I'll check these out.

Jack

I think you will find them useful. Continued success with your project.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.