smart key prompt in combo box

[bartw72]

Does anyone know how complicated would it be too allow the user to key in the first couple letters of the last name in the combo box & have the combo box prompt names that begin with those letters?

I thought I did this before, but I can't figure out how.

I would appreciate any advice.

 

[ejstefl]

If the name exists in the recordset for combo box, it will do this automatically. If not, I'm not sure how'd you go about it...

 

[Banana]

Set auto-expand property to yes.