Is there anyway to refresh a recordset without updating it and not loose the data already entered.

VB Code:
  1. rs.Open "SELECT T1.Foreign_Key, T2.Description_Of_The_FK FROM Table1 T1 INNER JOIN Table2 ON T1.Foreign_Key=T2.Primary_Key"

  2.  
  3. rs.AddNew 

  4.  
  5. rs.Fields("Foreign_Key") = 1  'After the user enters the FK, I would like the other the field to show the correct Value corresponding to 1 in the description field

  6. 'I can't update because in my prog, there are other not null fields

  7. 'And I can't retrieve the value myself and put it in the description, because then the RS is gonna try to INSERT in Table 2.

Is this possible ?? I don't think so, but maybe somebody has had something similar. Thanks