Access ’97-Problem with Listbox

I’m having trouble with a form I’ve made to display employee attendance history. The top of the form displays the most recent occurence a particular individual has had. The bottom of the form contains a listbox which shows all of the occurences forthis individual. I’m trying to create a combo box that will enable me to choose a different employee name and look at their record, but here’s what is happening: After choosing a name from the combo box, the top of the form displays the info I want, but the listbox remains static. How can I get the listbox info to change, too? I am new to VBA coding and cannot figure out how to fix this. Thanks in advance for any help you can provide.