I'm putting together a basic setup for a Food Pantry.  Client_Info_Table and Event_Log_Table are much like RR's CustomerT and ContactT with the field Client_ID linking the 2 tables.  I have a Search/Listbox form for finding the client.  A subform is supposed to show the Event_Log for each client as you click on them in the listbox.  At the moment, the subform only seems to work for the first client in the list (Client_ID=1).  Clicking on any other client only shows a blank new record for Client_ID=1.  There are no errors.  I went through the troubleshooting except for reinstall Access and reinstall Windows.  The Event_Log_Query has [Forms]![Client_Search_Form]![SearchList] as the Client_ID criteria.  SearchList is the name of the listbox.  The OnClick event runs the following:

Private Sub SearchList_Click()
    [Event_Log_Query_subform].Requery
End Sub  

Any direction would be appreciated.
Thanks,
Adrian