List Box Recordset auto update

[JC]

Hey Folks,

I am having a problem and I need some expert help. I am trying to
populate a list box with a record set based off of a table field on the
open procedure. I then want to have that list box adjust to what my
user inputs into the box. Example... user enters last name and the
list box scrolls through available values.

Once that is complete I want the user to click that value in the list
box and then have the form populate from that list box.

I know there is some code out there that I can use for this. I used it
when I worked with Access 2000 about 4 years ago. I am back to working
with this again. I just cannot find it.

Thanks you for your help,

Justin

 

[Guest]

If you use a ComboBox instead of a ListBox you can turn on the AutoExpand
property where it find the first record that matches what you type.

You can then use an Event property to refresh the form or requery the
underlying query.

 

[JC]

Thanks Karl,

I appreciate the help.

Justin

If you use a ComboBox instead of a ListBox you can turn on the AutoExpand
property where it find the first record that matches what you type.

You can then use an Event property to refresh the form or requery the
underlying query.