Opening select query as Dynaset (Inconsistent Updates)

[aziz rasul]

I have a query which includes two tables joined together over 4 fields. The query (call it Query1) is created by using QueryDef.

I want to update a particular field in Query1. I can do this manually by opening the query and selecting Dynaset (Inconsistent Updates) as the recordset type. However I want to do this using a recordset i.e.

Set rst2 = CurrentDb.OpenRecordset("Query1", ?)

What do I put in place of the ? to get it to Dynaset (Inconsistent Updates) mode so I can update the record.

Can I default to Dynaset (Inconsistent Updates) when I create the querydef?

 

[aziz rasul]

It's OK folks, I changed the query so that their were no joins.