combo box - HELP!!

[jackie1948]

I have a from with a combo box that I want to drop down a list of member after the last name is entered.
example:

1. enter 'jones' in combo box
2. click search button
3. I want the combo box to display all the members with
the last name of 'jones'
4. From this list I want to select one name (which will them be the one to be displayed in the combo box) to then display there history in a list box.

 

[Mike Gagnon]

jackie1948

How about using an "autofill" comboxbox as described in faq184-1792. Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first

 

[MichaelStoica]

How do you fill the combobox ? I sugest you to fill with a SQL statement with parameter beeing This.Value. Else you can declare a variable in the form and use this in the SQL. In the interactivechange event of the combobox you pass This.Value to the variable and then Requery.
Good luck