Access Visual Basic question

[PlayDoh]

I ma hoping someone will be familiar with Visual Basic in Microsoft Access. I am trying to create a function so when a user is typing a last name into a field the list box associated with the last name will automatically go to the letters being typed. For instance as I type Y...E...S the list box will show me all the letter Y's and then all the people with YE...etc. I would be acstatic if someone could help me out. I know it needs to go into a certain procedure but for the like of me I can't remember which one and I can't remember the actual code for that function either!!
Thanks in advance!!

[chriskeeble]

I think it's the OnChange event for the control you are using.

Eg. if you have a combo box with a drop-down list, write a procedure to select just records that match what you've typed so far and place it in (or call it from) the OnChange event procedure for the combo.

Hope that's right and helps!

------------------
Chris Keeble
www.giglist.com
mailto:chris.keeble@giglist.com

[Traci Thomason]

Go to the list box properties and select Auto Expand. This should be all that is necessary.