Using a table as a query criteria

Hi All,

I hope someone can help here. I have a table called Table1 with several
fields including ClientReference, i need to select only records which have
the client reference equal to all those records in a second table called
Table2 (which has ReferenceClient). Obviously i can add the table and do a
join between them but this then makes the recordset 'not updateable' and i
need to update some records. I assume i can use either dlookup or In () to
look up the values as a criteria in the query but i cannot make either work.

Please can anyone help.
Thanks
Emma
.