Requery a Resultset on same page??

I'm going to try to explain as best I can what I'm trying to do...

I've got a single page, no forms, that has two result sets.  I create one resultset(rsLoans) based on a value passed in on a querystring.  The second resultset(rsLoanDetails) is created from a value within the first resultset(loan_id).

I have two tables to display the information.  Table 1 displays all the loan information, table 2 shows the asset information pertaining to the loan displayed in table 1.  I have record selectors along the bottom, so that you can move through all the loans (the ones retrieved in rsLoans).  What I'd LIKE to happen, is for the information displayed in table 2 to automagically update with the appropriate information based on the new loan_id selected in table 1.  

Just to clarify a bit further, loan_id is the field that links rsLoans and rsLoanDetails.  This is a one-to-many relationship (ie. for each loan, there could be many items that were attached to that loan).  At present, everything works for the initial page load (because the resultset is being created on page load), but as soon as I go to the next loan (rsLoans record 2) the information displayed in Table 2 does not update it still displays the information retrieved from rsLoans record 1(rsLoanDetails was created with the loan_id from rsLoans from record 1).

Help! :)  Is there a way to requery a resultset??  Is this the most effective / efficient way to do what I want to do??  Thanks all for any assistance...

Shaymus Bane