Refresh Rs without Updating

[maxl]

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

rs.Open "SELECT T1.Foreign_Key, T2.Description_Of_The_FK FROM Table1 T1 INNER JOIN Table2 ON T1.Foreign_Key=T2.Primary_Key"
 
rs.AddNew 
 
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
'I can't update because in my prog, there are other not null fields
'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

[Beacon]

Use a disconnected recordset.

Basically retrieve the records then close the connection to the db.
You can still work with the recordset. But changes wont be made in the database.

b

[swatty]

You don't want to refresh ,but want to filter the rs.


You can use filter for this

rs.Filter = ""
rs.Filter = "Foreign_Key = "  & 1
' to remove the filter use 
rs.Filter = ""