Best Control for list of records in Access

[g3000]

I want to do a query on a table based on the last name selected from a
combo box.

So the after update on the combo box should use the value as a part of
a query.

I dont know what control I should use to list the results of a the
query.

Ive read that you cant bind a listview to data (query).

I want to be able to click on the record in the result set I want and
have the id of that record populate a control on the form.

So what control can I use that will allow me to click on a record in a
list and grab the value of a column in that list?

Any examples of creating a query and using that query to bind to a
control?

Im on Access 2003 on Win2k3 server.

Thank you for your time.

 

[g3000]

currently working on using a list box.

Having problem changing the rowsource for the list box to reflect the
selected value in my combo box.

 

[g3000]

thread closed