Hi Mailman,
I actually added the DISTINCT entry to try and resolve the problem - I have retried, removing DISTINCT, and I still have the same error.
Any other options to try?
Regards
Colin
Hi,
I joined the forum as I am getting nowhere is resolving a problem with a recordset - basically I want the update the related form but I get the message that the 'Recordset is not updateable.'
I'm using Access 2007 and the Recordset Type is 'Dynaset' - I've tried Dynaset (inconsistent...