[ms_access] help on queries

[Lyanne Rheeza Ong]

Hello, 
   
  I am getting an error that the statement below is not an updateable 
statement. My select statement works. When I modify the values of my update 
statememt, changing the select statement to hard coded values, it works. 
   
  UPDATE UsersAndUserClasses SET UsersAndUserClasses.AddUserClassSubmit = 
(SELECT 'AddUserClass,"' & Application.ApplicationName & '","' & 
Variable.ParentApplicationUserClassName & '"' AS Expr1
  FROM Variable, Application
  WHERE (((Variable.ApplicationUserClassName)=93) AND 
Variable.ApplicationUserClassName = Application.ApplicationID))
  WHERE 
(((UsersAndUserClasses.EListItemName)=[UsersAndUserClasses].[EListItemParentName]));
   
  thanks,
  lyanne



L y a n n e  R h e e z a  C.  O n g

 



       
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.

[Non-text portions of this message have been removed]