Well,as I said I have a view [V2].This view contains the following fields:ArticleID,ArticleTitle,ArticleDate and Flag.I have a VB form and I have 2 commands on it,with the first commandI want...

HiI tried ur statement and it didn't workWell,I can't update the field Flag because it is present in the where ClauseSELECT Article.ArticleDate, Article.ArticleID,Article.ArticleTitle, Article.ArticleLanguage, Source.ArticleSource, ...