Autofill or autotype?

[Bingo]

Hello again,

I'm trying to write a little search form that fills in possible
values while a user types in a text box. For instance, when the user
types "A" (in a non-bound box) I locate the first "A" record, then
they type "B" I find the the "Able Rug company" the "ABC insurance
agency" and so on.

But, I can't figure out how the get this work with the available
event hooks. KeyPress doesn't update the textbox, Change seems to
reset the insertion point (as well as selecting text), BeforeUpdate
doesn't fire for each key, etc.

I'm sure there's a way, but I defer to your collective expertise to
illuminate it! TIA - Rick

 

[Media Lint]

Why don't you merely use a combo box, populate the
rowsource appropriately and leave the "Auto Expand"
property set Yes (true).

This will be much more efficient than trying to duplicate
this functionality in VBA code, which will likely end with
user frustration at the sluggishness of your resulting
interface!

 

[Bingo]

Why don't you merely use a combo box, populate the
rowsource appropriately and leave the "Auto Expand"
property set Yes (true).

This will be much more efficient than trying to duplicate
this functionality in VBA code, which will likely end with
user frustration at the sluggishness of your resulting
interface!

The main problem with doing that is this is replacing an existng
application and that's the behavior they want.