[ms_access] help on query.. please help

[Lyanne Rheeza Ong]

Hello, 
   
  Please help on my query.. compile error expected end of statement error. 
   
  strSQL = "UPDATE UsersandUserClasses SET 
UsersandUserClasses.AddUserClassSubmit =  SELECT 'AddUserClass' + 
Variable.ApplicationUserClassName + Variable.ParentApplicationUserClassName as 
strText " _
            & "FROM Variable WHERE Variable.ApplicationUserClassName = '" & 
Me.cboApplicationName.value  & "'" ) ; "
   
      
    Debug.Print strSQL
    CurrentDb.Execute strSQL, dbFailOnError

  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]