currentdb.execute "UPDATE [" & dest & "] SET SOMESTRINGFIELD = " & myval
Yes Static this was the solution I was looking for. It works like charm.
Galaxion I did not want to rebuke anyone, nor did I use inappropriate language. Do not worry I put much more time to research on finding new and shorter ways to do things then to just accept what is written in the forum. This solution saved me a lot of coding in VBA.
Thanks a lot Static.