recordset not updateable

[philfer]

Hello,

Are only simple select query recordsets updateable?

When I create a form based on a query with even a simple join it wont let me update the recordset.

Is this always the case?

Thanks
Phil

[CreganTur]

It's my experience that any recordset with a Join is treated as not updateable. You'll have to use SQL to make any updates.