Make one control's selection determin how another control is populated

[Paul-ish]

I have a list box on a form and right now the list box lets me scroll through the names of people in my database. What I want to be able to do is click on one of the names in the list box, and then a set of controls adjacent to the list will be populated with data for that person so that I can edit and view their data. Is there a tutorial or person that can tell me how to do this? Thanks!

[Pat Hartman]

1. Create a form bound to a query that retrieves all the columns you want to display.
2. Add the listbox to the form.
3. Modify the query to refer to the listbox to limit the data displayed on the form.
Select ... From ... Where SomeField = Forms!YourForm!YourListBox;
4. In the click event of the listbox, requery the main form.
Me.Requery
That will cause the form to rerun its query which is now limited by the selection in the listbox.